Walter Hildebrandt wrote:
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)
IF*(A1=0*;*"no Div"*;A1-40+STYLE(IF*(A1>40*;"RedText")
, **(A1=0,
A1-40+STYLE(IF*(A1>40*;"RedText")
*and* **(A1>40?
"RedText"
*How does the A1-40+STYLE fit in?
No Idea.
--
Gene Y.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
