If Greater than or small than, or equal to

**ravisandhu** · 04-21-2009, 07:46 AM

Hi everyone,

I am not sure how to do this, I hope you can help.

I have a cell, M87.

The score in M87 can be less than 13 or greater than 25

I need a formula within M94 which refers to M87, and outputs depending on the the following criteria

If M87 is less than 13 then output as D

If M87 is 14, 15, 16, or 17 then output as C

If M87 is 18, 19, 20, 21, 22, 23 or 24 then output as B

If M87 is greater than 24 then output as A.

I hope you can help me with this formula.

I look forward to hearing from you.

Ravi

**NBVC** · 04-21-2009, 07:48 AM

Try

=Lookup(M87,{0,14,18,25},{"D","C","B","A"})

**KevinThomas** · 04-21-2009, 07:58 AM

Or the long winded way

=IF(M87<13,"D",IF(M87>13,IF(M87<18,"C"),IF(M87<25,"B","A")))

BTW if your result IS 13, it will return A as you are only asking for above or below values and not equal too.