I am trying to learn the syntax of the IF formula.so I can modify the formula into a new, modified formula.
There are three opened brackets (ISBLANK(A1), (A1=0, and (IF(A1>40). All the IF( must be closed with a corresponding closing bracket. the closing brackets at the end of the formula seems to be doing the following; IF(ISBLANK(A1);"Empty";A1-40+STYLE(IF(A1>40;"RedText") The False is A1-40+STYLE(IF(A1>40;"RedText")) and I do not know what that means. The same thing is true for the IF(A1=0; The A1-40+STYLE(IF(A1>40;"RedText")) is the False Am I correct that the above is saying A1-40+STYLE(IF(A1>40;"RedText" (RedText) is the False answer for these two Ifs? There is no; before the (IF(A1>40). How do account for the third opened bracket? The STYLE function can change the style of the current cell as a “side effect”. In this case the STYLE function is being told to change the style of the current cell depending on the value of A1 Does this means the cell style RedText will control the formatting of the current cells? Does this mean if another style is created, that new cell style can be entered in the formula in the place of RedText? The only thing I did in setting up the RedText cell style was putting RedText as the name in the Organizer and selected Light Red in place of Automatic in the Font Effects. Walter 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? >> >> >> >
