2009/11/12 Walter Hildebrandt <[email protected]>: > I am still confused of the semicolons. The following is a color coded > summary of what you have said. > > 1st IF > > =IF(ISBLANK(A1) ;*"Empty"*;*IF(A1=0;"no Div";A1-40+STYLE(IF(A1>40;"RedText"* > )))) > IF(ISBLANK(A1) (test) > *"Empty" (True)* > *IF(A1=0 ;"no Div";A1-40+STYLE(IF(A1>40 ;"RedText"))) (False)* > > > The function +STYLE changes the style of the current cell so that the *True > *and *False* for this IF is in effect. The RedText style only take effect if > *False* is the result in the current cell > 2nd IF > > =IF(ISBLANK(A1) ;"Empty";IF(A1=0;*"no Div"*;*A1-40+STYLE(IF(A1>40;"RedText"* > )))) > > IF(A1=0 (test). > *"no Div" (True)* > *A1-40+STYLE(IF (A1>40 ;"RedText")) (False)* > > > The function +STYLE changes the style of the current cell so that the *True > * and *False* for this IF is in effect The RedText style only take effect if > *False* is the result in the current cell > 3rd IF > > =IF(ISBLANK(A1) ;"Empty";IF(A1=0;"no Div";A1-40+STYLE(IF(A1>40;*"RedText"* > )))) > > IF(A1>40 (test) > *"RedText" (True)* > *(formula is blank) (nothing is done) (False)* > False is omitted therefore the result is zero/blank/null depending on > context. In this case either will work because STYLE(""), STYLE(0) and > STYLE(" ") all have the same effect - "do nothing". > > The function +STYLE changes the style of the current cell so that the > *True*and > *False* for this IF is in effect. The RedText style take effect if *True* is > the result in the current cell > > For the 1st IF, what is the "rule" or "principal" that caused the semicolon > at the end of the following to be in effect? > =IF(ISBLANK(A1) ;*"Empty"*;*IF(A1=0;"no Div";* > > > > What is the “rule” or “principal for the 2nd IF. The semicolon at the end of > the following seems to work correctly > =IF(ISBLANK(A1) ;"Empty";IF(A1=0;*"no Div"*; > > however the semicolon after the 40 and before “RedText” did not seem to take > effect > > Walter
That semicolon is in the third IF statement. And there seem to be one missing there, by the way. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
