Hi Walter
I think the * represents BLANKs in your formula the the result in
IF*(**ISBLANK(A1)*;
/ then/ *"Empty"*;
/else/ IF*(A1=0*;
/then/ *"no Div"*;
/else/ A1-40+STYLE( IF*(A1>40*;
/ then/"RedText")
/endif/)
endif)
/endif/)
I wrote the then/else/endif statements in/* kursiv */in your formula. I
think ist clear what happen.
Franz
Walter Hildebrandt schrieb:
I have the following formula:
IF*(**ISBLANK(A1)*;*"Empty"*;IF*(A1=0*;*"no Div"*;A1-40+STYLE(IF*(A1>40*;
"RedText"))))
The syntax of an IF consists of three components:
1.
*The condition*
2.
*What to do if the condition is true*
3.
*What to do if the condition is false*
What is the syntax is the above formula? Where is the *false condition* for
the *(**ISBLANK(A1), **(A1=0, *and* **(A1>40?
*How does the A1-40+STYLE fit in?
