Nested IF and Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top