Nested IF

[Guest]

Hi
I know how to write out the nested if functions but was wondering can the
wizard handle it. It seems that there are only 3 boxes in the wizard,
Condition, True, False how do I increase the number of boxes?

Many thanks

 

[Guest]

What wizard are you referring to? There are many in Excel.

Explain what you're trying to accomplish and likely someone can tell you how
to do it.

Dave

 

[Guest]

if you want to use the wizard, you will have to write the nested if in one of
the three boxes, the if-wizard will not show more boxes.

 

[Guest]

The wizard for the IF function is what I was asking. Is it possible to have
more boxes appear while in the IF Function Wizard or do I have to write out
the whole nexted IF function.

=if(condition,true,if(condition,true,if(condition,true,false)))

Can the IF Function Wizard offer me enough sections to complete a nested if?

Many thanks

 

[Sasa Stankovic]

yes,
wizard is able to produce nested functions, but
when you nedd to invoke second function you go to name box and select from
there..

sasa