Hi Margaret
What does the B$10,2 mean?
=VLOOKUP(A1,Sheet2!$A$2:$B$10,2)
this says that the table you're looking for the grade in to return the
result is on sheet2 starting at A2 and going to B10
so you need to adjust this to the sheet name & range of your actual data.
the 2 tells Excel that you want to find the value that you've typed in A1 in
sheet2! column A and return the associated bit of information from column B
(ie the 2nd column of the table)

the A1 is where the student's score is

Should the number appear in the column that I am typing the function in?
- not sure what you mean by this

Does it matter how many grade boundaries I type in?(+ and - for each
grade)
no as long as they are single numbers and in ascending order (as per my
example)

if this doesn't help, please post back with the sheet name and references of
your "lookup" table
and the cell reference of the first student's result that you want to return
the grade for.

Cheers
JulieD



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