do nested if statement in excel have limitation

[icekube88]

do nested if statement in excel have limitation? coz my 9th if statemen
got an error, i think it can only handle upto 8 nested if. what othe
alternative would replace nested if :confused

 

[Harald Staff]

Hi

7. See
http://www.cpearson.com/excel/nested.htm
on this and possible workarounds.

 

[curllion]

you can use the if statement as below
={SUM(IF(($B$2:$B$12372=$A$1)*($C$2:$C$12372=$A3)*($H$2:$H$12372=C$2),$E$2:$
E$12372,))}
the value of true is 1 and the value of false is 0,
so using ONE if statement can solved the problem.

 

[Dave Hawley]

Hi,

The limit is seven. If you get close to this it normally means you
should be using another formula. Often the use of a Lookup table or the
Choose function etc.

If you would like to post you needs I'm sure I could help.

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****