FORMULA PROBLEM "IF"

Posted by Rachel on October 08, 2001 10:47 PM

FORMULA PROBLEM

Please help. I am having problems with the following formula.

=IF(OR(H6>=1,I6>=2),"VH",(IF(OR(H6&LT;1,I6=1,J6>=3),"H",(IF(OR(J6&LT;3),"M")))))

Kind regards,

Posted by Aladin on October 08, 2001 11:34 PM

Rachel,

Care to explain what you want in ordinary English?

Aladin

=======

Posted by Rachel on October 08, 2001 11:47 PM

What I want is if cell H6 is greater than 1 and cell I6 is greater than 2 then return VH which is "very high" or if cell H6 is less than 1 and I6 equals 1 but J6 is greater than 3 return H for high or if J6 is less than 3 return M for medium.

Does this help explain?

Kind regards.

Rachel

Posted by Tom Urtis on October 09, 2001 5:02 AM

Aladin, sorry to barge in but I got up early today.

Try this formula Rachel, it worked for me:

=IF(AND(H6>1,I6>2),"VH",IF(AND(AND(H6&LT;1,I6=1),J6>3),"H",IF(J6&LT;3,"M","")))

In your formula, you had too many arguments in your "H" Or structure.

Tom Urtis