K
Kostis Vezerides
Bill,
in cases like this, VLOOKUP() is the ideal function. One
more note before I continue, your condition C4>98.49, is
safer for what you want if you replace it with C4>=98.5,
which I suspect is your intention.
How to proceed:
Go to a column and write the grade interval numbers in
ascending order, starting with 0. Next to them write the
grade that corresponds to the interval *starting* with the
number. Suppose you do this in columns J:K
J K
------
0 F
60 D-
63.5 D
68.5 D+
........
98.5 A+
Then use the formula
=VLOOKUP(C4, J:K, 2, TRUE)
Modify the numbers as necessary.
HTH
Kostis Vezerides
the results required that fits the parameters of nested if.
(C4>74.49,"C+",IF(C4>69.49,"C","F",IF(AND
in cases like this, VLOOKUP() is the ideal function. One
more note before I continue, your condition C4>98.49, is
safer for what you want if you replace it with C4>=98.5,
which I suspect is your intention.
How to proceed:
Go to a column and write the grade interval numbers in
ascending order, starting with 0. Next to them write the
grade that corresponds to the interval *starting* with the
number. Suppose you do this in columns J:K
J K
------
0 F
60 D-
63.5 D
68.5 D+
........
98.5 A+
Then use the formula
=VLOOKUP(C4, J:K, 2, TRUE)
Modify the numbers as necessary.
HTH
Kostis Vezerides
better way of doing, more importantly one that will return
the results required that fits the parameters of nested if.
(C4>87.49,"B+",IF(C4>83.49,"B",IF(C4>79.49,"B-",IF
(C4>74.49,"C+",IF(C4>69.49,"C","F",IF(AND