On Wed, Nov 11, 2009 at 11:38 AM, Gene Young <[email protected]> wrote:
> Walter Hildebrandt wrote: > >> 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 >> >> My apologies. I failed to notice that you left out a condition. You > need to change the last if statement to add the false condition: > The formula is working fine now. The numbers that are suppose to be black are black and that numbers that are suppose to be red are red. Also the text is the color it should be. A cell Style named RedText has been created and the STYLE in the formula somehow activated the RedText style to give the correct results in the various cells involved. Somehow the false condition is included. > > IF*(A1>40*;"RedText";"") > > This states that if your condition is true, "RedText" if it is false, null. > You could of course put any other action in for false, but you must have > the else condition. > > > > > -- > Gene Y. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
