mahadeshwar
05-18-2006, 03:43 PM
Hi all,
Can you help? Tony did this brilliant code
=IF(OR(AND(D2<=3,E2=1),AND(D2<=2,E2=2)),"VLOW","")
But I have these two conditions that I need to nest into the IF statement so that it does all the comparison or one value in the cell and prints the word, but I don't know how.
See conditions below
IF(OR(AND(D2>=3,E2=3),AND(D2<=2,E2=4)),”MEDIUM”),
IF(OR(AND(D2>=3,E2=4),E2=5),”HIGH”)
Post edited by geekgirlau 19-May-06. Reason: retype to remove "shouting"
Can you help? Tony did this brilliant code
=IF(OR(AND(D2<=3,E2=1),AND(D2<=2,E2=2)),"VLOW","")
But I have these two conditions that I need to nest into the IF statement so that it does all the comparison or one value in the cell and prints the word, but I don't know how.
See conditions below
IF(OR(AND(D2>=3,E2=3),AND(D2<=2,E2=4)),”MEDIUM”),
IF(OR(AND(D2>=3,E2=4),E2=5),”HIGH”)
Post edited by geekgirlau 19-May-06. Reason: retype to remove "shouting"