|
|
|
|
"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
|