PDA

View Full Version : Conditional Formatting



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"

acw
05-18-2006, 06:02 PM
Hi

Try


=IF(OR(AND(D2<=3,E2=1),AND(D2<=2,E2=2)),"VLOW",IF(OR(AND(D2>=3,E2=3),AND(D2<=2,E2=4)),"MEDIUM",
IF(OR(AND(D2>=3,E2=4),E2=5),"HIGH")))


Tony

geekgirlau
05-18-2006, 07:45 PM
Hi Mahadashwar,

I've edited your post to make the title relate to you problem - "help" is not very specific, and you'll get a much better (and quicker) response if people have some idea what the problem is from the title.

I've also retyped your post so that it's not in uppercase. In netiquette terms, this is known as "shouting" and is usually considered bad manners.