Nested IF and Wizard
 

Hi I notice when I do the standard IF function using the Wizard I am given
three boxes:

Argument

True

False

Is there a way to use the Function Wizard to do a nested IF and if so how do
I get more boxes?

Many thanks
--
Kind regards

Ann Shaw

Nested IF and Wizard
 

When you say "function wizard" what exactly are you referring to? My guess
is most respondents to these posts don't use wizards but rather create their
formulas from scratch.

Also, if it helps, nested IF functions generally have the form IF THEN ELSE
IF THEN ELSE, i.e., =IF(A1=B1,C1+D1,IF(A1=E1,F1+G1,H1+I1))

If A1 equals B1, THEN C1 + D1, ELSE IF A1 equals E1, THEN F1 plus G1, ELSE
H1 plus I1.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Annie" wrote:

Hi I notice when I do the standard IF function using the Wizard I am given
three boxes:

Argument

True

False

Is there a way to use the Function Wizard to do a nested IF and if so how do
I get more boxes?

Many thanks
--
Kind regards

Ann Shaw