View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default Nested conditional statements

Hi,

Please put your questions into the body of the post. It causes problems in
some web browsers.

In Excel 2003 you can do 7 levels of nesting and in 2007 64. In the
spreadsheet the basic form is

=IF(A110,5,IF(A15,2,0))

You might post exactly what you are trying to do because nested IF's may not
be the appropriate or best solution.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"unknown" wrote: