If Statements

  • Thread starter Thread starter Julie
  • Start date Start date
J

Julie

Hello! I have done this before but I can not remeber how!

I want to create an "IF" statmenet to select a given cell depending on a
range. For example - Grading Scale. If Cell A1 is between 100 and 96 then
"A", if cell A1 is between 95 and 89 then "B" ect....

Thank You!
Julie
 
This is quite a common question - you could always try searching other
posts.

The use of IF is not really recommended, because there is a limit in
earlier versions of Excel of 7 nested formulae. An alternative is to
set up a table somewhere in your worksheet and list the grades and
ranges there, then you can use VLOOKUP to extract the appropriate
grade.

Hope this helps.

Pete
 
I don't know how to use the Vlookup. I tried it but i am doing something
wrong because I'm getting an error of #N/A.

I searched for If statements in the discussion board and no results
appeared. I was surprised myself.
 
Thank you, i figured out how to use the Vlookup properly! That is exactly
what I was looking for :)
 
Until you learn VLOOKUP, use this:

=IF(A2>89,"A",IF(A2>79,"B", IF(A2>69,"C",IF(A2>59,"D","F"))))

Change the cell reference and grading range as needed.

Les
 
Okay, tell me what grades you will be using and what marks these
relate to. Can you also describe the layout of your data, eg what
column has your mark, where does your data start, how many rows and
columns of data do you have etc.

Pete
 
Back
Top