Margaret

=LOOKUP(A1,{0,40,50,60,70,80,90,100},{"E","D","C-","C","C+","B","B+","A"})

Adjust ranges and letter scores as required.


Gord Dibben Excel MVP

On Sat, 5 Feb 2005 06:59:02 -0800, "Margaret"
wrote:

Thank you, Julie.
Can I write a series of inequalities? I am a teacher and I want the grade
to be posted in the column. So if my grade boundaries are the followin:
95-100 is an A+, 90-95 is an A... and so on for the rest of my grades
Thanks,
Margaret

"JulieD" wrote:

Hi Margaret

=IF(AND(A120,A1<40),5,0)

where x = A1

Cheers
JulieD

"Margaret" wrote in message
...
How do I write an inequality in excel? For example, if 20<x<40 then write
5
in the