ExcelBanter - if(and(

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if(and( (https://www.excelbanter.com/excel-discussion-misc-queries/183682-if.html)

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

=IF(ISLOGICAL(IF(AND(A11="m";B11="y";C11="y");7500 000+2500000+500000*E11;IF(AND(A11="m";B11="y";C11= "n");7500000+E11*500000;IF(AND(A11="m";B11="n");75 00000+E11*500000;IF(AND(A11="f";B11="y";D11="y");7 500000+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 ??

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

Tyro

"pierre" wrote in message
...
how many successive if(and( can i make in a formula ??

=IF(ISLOGICAL(IF(AND(A11="m";B11="y";C11="y");7500 000+2500000+500000*E11;IF(AND(A11="m";B11="y";C11= "n");7500000+E11*500000;IF(AND(A11="m";B11="n");75 00000+E11*500000;IF(AND(A11="f";B11="y";D11="y");7 500000+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 ??