if(and(

  • Thread starter Thread starter pierre
  • Start date Start date
P

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 ??
 
Back
Top