Thread: Nested IF
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Annie Annie is offline
external usenet poster
 
Posts: 103
Default Nested IF

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
--
Kind regards

Ann Shaw


"Dave F" wrote:

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

--
Kind regards

Ann Shaw