Whats wrong with my formula

[ksuthy]

Hello,

anyone want to take a stab at what is wrong with my formula?

=if(and([@inches]=0,[@[Length feet]]=6),6,if(and([@inches]=0,[@[Length feet]]=8),8,if(and([@inches]=0,[@[Length feet]]=10),10,if(and([@inches]=0,[@[Length feet]]=12),12,if(and([@inches]=0,[@[Length feet]]=14),14,if(and([@inches]=0,[@[Length feet]]=16),16,if(and([@inches]=0,[@[Length feet]]=18),18,if(and(([@inches]=0,[@[Length feet]]=20),20,if(and([@inches]=0,[@[Length feet]]=22),22,if((and([@inches]=0,[@[Length feet]]=24),24,IF(SUM([@[Length feet]]+([@inches]/12))<6),6,IF((AND(SUM([@[Length feet]]+([@inches]/12))<8,[@[Length feet]]+([@inches]/12)>6)),8,IF(AND(SUM([@[Length feet]]+([@inches]/12))<10,[@[Length feet]]+([@inches]/12)>8),10,IF(AND(SUM([@[Length feet]]+([@inches]/12))<12,[@[Length feet]]+([@inches]/12)>10),12,IF(AND(SUM([@[Length feet]]+([@inches]/12))<14,[@[Length feet]]+([@inches]/12)>12),14,IF(AND(SUM([@[Length feet]]+([@inches]/12))<16,[@[Length feet]]+([@inches]/12)>14),16,IF(AND(SUM([@[Length feet]]+([@inches]/12))<18,[@[Length feet]]+([@inches]/12)>16),18,IF(AND(SUM([@[Length feet]]+([@inches]/12))<20,[@[Length feet]]+([@inches]/12)>18),20,IF(AND(SUM([@[Length feet]]+([@inches]/12))<22,[@[Length feet]]+([@inches]/12)>20),22,FALSE))))))))))))))))))))

 

[ksuthy]

ah yes - but that is an error that excel tolerates i guess - though it is reduntant

 

[sandy666]

tolerate does not mean it is correct but it's up to you