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 **
When your cursor is in a writer table, press F2 to get a formula entry bar. Near the left side if the bar is the symbol fx. The pull-down for fx shows the functions available for writer tables. the function IF is not there.
You can probably make your application work by embedding a calc table in your writer document.
Hi @Instigater,
I’m a bit confused by the formatting of your question, so I’m not exactly sure what you’re asking. Could you please reformat your question using the <code> formatting? Just indent at least 4 spaces, and the lines will format as monospace, line breaks, syntax highlighting, etc…
e.g.
=if( (<table2.b4> - <table2.b3>) < 1095; 0.00 = 0.15)
gives me 0.15, but
=if( (<Table2.B4> - <Table2.B3>) < 1095;
…etc
I reformated question. Is it clear now?
yep, much better!
Why are the “<” and “>” used?
I don’t see a need for these symbols. Could they be the route cause?
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.