Including a range of number in a IF (Logical Test) formula

Z

Zakhary

Isn't there a "RANGE" formula that can be used complimentary with the IF
formula?

I am grading some students' work and am looking to have a IF formula that
divides the students' numeric points earned by the number of possible points
and have the conditions be as follows:

RANGE GRADE
..9-1 A
..8-.89 B
..7-.79 C
..6-.69 D
0-.59 F

What I tried was this:
=IF(C7/C6=RANGE(.9,1),"A",IF(C7/C6=RANGE(.8,.89),"B",IF(C7/C6=RANGE(.7,.79),"C",IF(C7/C6=RANGE(.6,.69),"D","F"))))

However, this did not work because I am either using the RANGE formula
incorrectly or this formula doesn't even exist.

-Zakhary
 
T

T. Valko

Try this:

=IF(COUNT(C6:C7)<2,"",LOOKUP(C7/C6,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"}))

Biff
 
G

Gord Dibben

Zakhary

No such function as RANGE

Try this as an alternative.

=LOOKUP(C7/C6,{0,0.6,0.7,0.8,0.9},{"F","D","C","B","A"})


Gord Dibben MS Excel MVP
 
Z

Zakhary

The only problem with this resolution is thaty it only will include numbers
that are greater than .9, but not equal to. .9 need to be included
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top