Nested IF and Wizard

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Annie - 03 Apr 2007 13:04 GMT

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

Signature

Kind regards

Ann Shaw

Reply to this Message

Dave F - 03 Apr 2007 13:40 GMT

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

Signature

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

> Hi I notice when I do the standard IF function using the Wizard I am given
> three boxes:
[quoted text clipped - 9 lines]
>
> Many thanks

Reply to this Message