do nested if statement in excel have limitation

  • Thread starter Thread starter icekube88
  • Start date Start date
I

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
 
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.
 
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 *****
 
Back
Top