if(and(

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Active XText box vbcr shows symbol instead of an actual carraige return 2
Help with a simple formula! 8
How Check some cells have been updated 4
Problem programming a formula 5
Biweekly timesheet formula error 3
Return a value if a range of cells contain text 2
Data Reporting to a cell 0
Remove #N/A Error 3

Top