Ask Your Question
1

Does Writer support nested IF statements? [closed]

asked 2012-12-12 21:04:03 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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 *

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-19 13:15:39.416307

5 Answers

Sort by » oldest newest most voted
1

answered 2012-12-13 15:42:44 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit flag offensive delete link more
0

answered 2012-12-13 10:23:45 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

Why are the "<" and ">" used?

I don't see a need for these symbols. Could they be the route cause?

edit flag offensive delete link more
0

answered 2012-12-13 08:34:25 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I reformated question. Is it clear now?

edit flag offensive delete link more

Comments

yep, much better!

qubit gravatar imagequbit ( 2012-12-13 08:48:53 +0100 )edit
0

answered 2012-12-13 11:28:14 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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.

edit flag offensive delete link more
0

answered 2012-12-13 03:53:02 +0100

qubit gravatar image

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

edit flag offensive delete link more

Question Tools

Stats

Asked: 2012-12-12 21:04:03 +0100

Seen: 719 times

Last updated: Dec 14 '12