Option 1
======
http://cpearson.com/excel/excelF.htm#Grades

Option 2
======
Have a look at this thread. via Bob Umlas.

From: BobUmlas ()
Subject: Vlookup also
View: Complete Thread (3 articles)
Original Format
Newsgroups: microsoft.public.excel.worksheetfunctions
Date: 1999/07/12


Set up the table like this (5 rows, 2 columns)
0 F
60 D
70 C
80 B
90 A
Name these 5r x 2c "Grades" (Not required, but good practice).
To find someone's grade using the value from column K, enter
=VLOOKUP(K2,Grades,2)
Where K2 is one of the grades. The 2 in the formula says to return the value
from the 2nd column of the table called "Grades".

Option 3
======
Microsoft Education resources
http://www.microsoft.com/education/Default.aspx

Various educational planning templates
http://office.microsoft.com/en-us/te...100821033.aspx

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Margaret" wrote in message
...
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