Ask Your Question

Instigater's profile - activity

2013-07-28 07:57:20 +0200 received badge  Famous Question (source)
2013-07-28 07:57:20 +0200 received badge  Notable Question (source)
2013-07-28 07:57:20 +0200 received badge  Popular Question (source)
2012-12-13 11:28:14 +0200 answered a question Does Writer support nested IF statements?

They are added automaticaly when formula was made using F2 key and selecting cells in table with mouse.

Tried without < and >

The same error with nested IF and no error if just one IF is used.

2012-12-13 08:49:51 +0200 received badge  Student (source)
2012-12-13 08:34:25 +0200 answered a question Does Writer support nested IF statements?

I reformated question. Is it clear now?

2012-12-13 08:29:34 +0200 received badge  Editor (source)
2012-12-12 21:04:03 +0200 asked a question Does Writer support nested IF statements?

LibreOffice 3.6.4 English (US) on Windows.

Why do I get "* Expression is faulty *" if I try to use nested IFs in writer?

Example: <Table2.B4>-<Table2.B3> is about 1300

=if((<Table2.B4>-<Table2.B3>)<1095; 0.00; 0.15)

gives me 0.15

but

=if((<Table2.B4>-<Table2.B3>)<1095; if((<Table2.B4>-<Table2.B3>)<730; 0.00; 0.1); 0.15)

gives me * Expression is faulty *