I am trying to set a letter grade for my students, HELP
 

I followed the formula that help suggested, it was a IF statement, one way it
turns out false, the other way the only grade that will show is an A. The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it
alwasy returns an A, now the students would like that, but, I would have a
hard time explaining why everyone got the same grade. Help if you can.
Thank You, this is my first post.

"UTI Rod" <UTI ha scritto nel messaggio
...
I followed the formula that help suggested, it was a IF statement, one way
it
turns out false, the other way the only grade that will show is an A. The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it
alwasy returns an A, now the students would like that, but, I would have a
hard time explaining why everyone got the same grade. Help if you can.
Thank You, this is my first post.

Hy,
try to these:
=VLOOKUP(H24,{0,"F";69,"C";79,"B";89,"A"},2)

Im italian, i don't know the exact score.
ivano

In your formula, if value in H24 LESS than 89 then put A, (everything
less than 89 will become A) else go to the next IF statement.

In this case if the value than 89 then 2nd IF will be triggered. But
the statements in this IF are all LESS than 89.

I think your formula may be like this.
=IF(H2489, "A", IF(H2479,"B", IF(H2469, "C","F")))

Only change the LESS THAN symbol to MORE THAN symbol.

Please forgive for my bad English.


--
hideki
------------------------------------------------------------------------
hideki's Profile: http://www.excelforum.com/member.php...o&userid=18903
View this thread: http://www.excelforum.com/showthread...hreadid=397481

The formula starts calculating from the left, and stops when the condition
is satisfied.
So, if H24 contains 50, read what you entered:

If H24 is less then 89, return A.
SO ... that's what happened!
50 is less then 89, so you got what you asked for ... yes?

Now, to get what you *want*, simply reverse the order of the arguments:

I'm sure you can do that yourself ... right?
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"UTI Rod" <UTI wrote in message
...
I followed the formula that help suggested, it was a IF statement, one way
it
turns out false, the other way the only grade that will show is an A. The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it
alwasy returns an A, now the students would like that, but, I would have a
hard time explaining why everyone got the same grade. Help if you can.
Thank You, this is my first post.

try changing < to

--
Don Guillett
SalesAid Software

"UTI Rod" <UTI wrote in message
...
I followed the formula that help suggested, it was a IF statement, one way
it
turns out false, the other way the only grade that will show is an A. The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it
alwasy returns an A, now the students would like that, but, I would have a
hard time explaining why everyone got the same grade. Help if you can.
Thank You, this is my first post.

You may want to consider using VLOOKUP instead of the nested IF statements.
Then you can change the grading scale more easily.

Grade Scale Table:
0 F
59.5 D
69.5 C
79.5 B
89.5 A


Set up a table like the one above and use:
=VLOOKUP(C1,$A$1:$B$5,2)

Assumes cell C1 contains the grade you are looking up, and the table is in
range A1:B5.

"UTI Rod" <UTI wrote in message
...
I followed the formula that help suggested, it was a IF statement, one way
it
turns out false, the other way the only grade that will show is an A. The
formula is as follows:
=IF(H24<89, "A", IF(H24<79,"B", IF(H24<69, "C","F"))). When I try this it
alwasy returns an A, now the students would like that, but, I would have a
hard time explaining why everyone got the same grade. Help if you can.
Thank You, this is my first post.