Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ?? |