if(and(

[pierre]

how many successive if(and( can i make in a formula ??

=IF(ISLOGICAL(IF(AND(A11="m";B11="y";C11="y");7500000+2500000+500000*E11;IF(AND(A11="m";B11="y";C11="n");7500000+E11*500000;IF(AND(A11="m";B11="n");7500000+E11*500000;IF(AND(A11="f";B11="y";D11="y");7500000+E11*500000;IF(AND(A11="f";B11="y";D11="n");7500000; []--------> here i would like to add an
if(and before closing the if(islogical


IS IT POSSIBLE ??

 

[Tyro]

In Excel 2003 and earlier you can nest IF's to 7 levels.

Tyro