On Wed, Nov 11, 2009 at 10:00 AM, Gene Young <[email protected]> wrote:
> 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") > > Am I correct that you are saying that A1-40+STYLE(IF*(A1>40*;"RedText"))))is > the #3 False condition for both (ISBLANK(A1) and (A1=0) Am I correct that you are saying "RedText" is the #3 False condition for (A1>40 even where it seems to be the #2 True condition since there is only one condition after the (A1>40 , **(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] > >
