In Excel, how many nested "IF Statements" can you produce b4 the computer gets confused?

Excel 2007 and Excel 2010 are capable of nesting 64 levels of formulas.

In earlier Excel versions, you could only nest formulas up to 7 levels.

.

Hmm, straightforward sufficient. even with the indisputable fact that, i will nonetheless insist on calling it "chivalry" even as my husband is going out in a snow fall for ice cream and pickles even as i'm pregnant. he's my knight, what am i able to assert. i'm into courtesy, yet what about courtesies that are prolonged because of gender? even as a guy deals with a mouse or a trojan horse it is gotten into the room, and the female stands round screaming, is he merely being courteous? Why might want to the reproductive-evolution-depending desire for a guy to coach that he will guard his woman be "useless"? Are women individuals going to end wearing lipstick, too?

It looks like 7.

Have fun.

I doubt whether it depends on 32 bit or 64 bit machine.

Certainly compiler technology also improved.

I wrote a simple code added about 30 elseifs and tested in Bloodshed c++

It did work

#include<stdio.h>

#include<stdlib.h>

int main()

{

int n;

scanf("%d",&n);

if(n==1)printf("1\n");

else if(n==2)printf("2\n");

else if(n==3)printf("3\n");

else if(n==4)printf("4\n");

else if(n==5)printf("5\n");

else if(n==6)printf("6\n");

else if(n==7)printf("7\n");

else if(n==8)printf("8\n");

else if(n==9)printf("9\n");

else if(n==10)printf("10\n");

else if(n==11)printf("11\n");

else if(n==12)printf("12\n");

else if(n==13)printf("13\n");

else if(n==14)printf("14\n");

else if(n==15)printf("15\n");

else if(n==16)printf("16\n");

else if(n==17)printf("17\n");

else if(n==18)printf("18\n");

else if(n==19)printf("19\n");

else if(n==20)printf("20\n");

else if(n==21)printf("21\n");

else if(n==22)printf("22\n");

else if(n==23)printf("23\n");

else if(n==24)printf("24\n");

else if(n==25)printf("25\n");

else if(n==26)printf("26\n");

else if(n==27)printf("27\n");

else if(n==28)printf("28\n");

else if(n==29)printf("29\n");

system("PAUSE");

return 0;

}