If you had tried the formula first, before asking additional questions, you
would have discovered that it *does* work exactly as you wish.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Preston Steele" wrote in message
...
Would it be possible to include all number, like 0-59, 60-69 - Like
=LOOKUP(E16,{0 to 59,60 to 69,70 to 79,80 to 89,90 to
100},{"F","D","C","B","A"})? How would this formula be typed out?

"Elkar" wrote:

You could use the LOOKUP function. Something like:

=LOOKUP(A6,{0,60,70,80,90},{"F","D","C","B","A"})

You can add more numbers/grades if you want to include + and - grades.

HTH,
Elkar


"Preston Steele" wrote:

I am trying to create several linked spreadsheets to form a grading
system
for class. I have most of the formulas down; however, I am trying to
get a
cell that pulls from two other cells (50% for classroom, pulled from
another
worksheet and 50% for lab, also pulled from another worksheet, totaled
in A6)
that now shows a percentage (87% in A6) to show as a B in cell A7. How
do I
do this?