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