Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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:


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Nested conditional statements Harlan Grove[_2_] Excel Worksheet Functions 0 June 7th 09 09:50 PM
Nested conditional statements David Biddulph[_2_] Excel Worksheet Functions 0 June 7th 09 07:54 PM
Nested If Statements Sarah_Lecturer Excel Worksheet Functions 5 March 18th 09 02:53 AM
Nested IF statements using AND / OR Joe[_13_] Excel Worksheet Functions 2 February 9th 09 06:14 PM
I want to use more than 7 nested if then statements IF I only had a brain for IF statements Excel Worksheet Functions 11 August 9th 05 01:28 AM


All times are GMT +1. The time now is 09:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"