Formula Problem - URGENT HELP PLEASE
Posted by Rachel on October 09, 2001 2:07 AM
Having problems with the following Excel formula. Do you know what is wrong with it?
=IF(OR(H6>=1,I6>=2),"VH",(IF(OR(H6<1,I6=1,J6>=3),"H",(IF(OR(J6<3),"M")))))
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.
Regards,
Posted by Harry on October 09, 2001 3:02 AM
Rachel
A colleague of mine (Pete) has suggested this- it seems to work.
=IF(J6<3,"M",IF((AND(H6>1,I6>2)),"VH","H"))
Posted by Eric on October 09, 2001 4:13 AM
Harry's fix is definitely shorter, but your's works if you replace the ORs with ANDs
Also the last section (If(OR(J6<3)...
the OR statement can be removed
HTH
Posted by Rachel on October 09, 2001 4:23 AM
Thank You
Thank you to you both for your help.
Kind regards.
Rachel
