Hi Julie,
When I typed in the function, I got the message #N/A.
What does the B$10,2 mean?
Should the number appear in the column that I am typing the function in?
Does it matter how many grade boundaries I type in?(+ and - for each grade)
Thanks,
Margaret

"JulieD" wrote:

Hi Margaret

yes you can (in fact this is the example i give my students), however you
can only nest 7 IF functions
e.g.
=IF(A1=95,"A+",IF(A1=90,"A",IF(A1=80,"B+","valu e_if_false")))
is already 2 nested ifs

so an alternative is to use the VLOOKUP function, to do this you need to
list your grade boundaries in ascending order and the associated grade next
to them
e.g. on Sheet2
........A.....................B
1....Grade...........Result
2......0....................F
3.....50...................P
4.....60...................D
5.....70...................C
etc
then when you're determining the result use the following formula
=VLOOKUP(A1,Sheet2!$A$2:$B$10,2)

this says look up the value in A1 (ie the student's score) in column A of
sheet2 and return the matching result in the second column of this table.

Hope this helps
Cheers
JulieD


"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