Thanks for your help, Ken. I am not sure how to write greater than or equal
to and am not sure what to do if I have multiple inequalities.
If I have multiple inequalities for a row would I write the following:

=IF(AND(xOR=20,x<40),5), (IF(AND(xOR=40,x<60),6)),( IF(AND(x=OR60,X<80),7))

Thanks,
Margaret
"Margaret" wrote:

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