I need a Formula

K

Karen

I need a formaula to do the following. If the total in cell A1 is between
0-60 I want it to display the word Pass in cell B1. If the If the total in
cell A1 is between 61-80 I want it to display the word Credit in B1. If the
If the total in cell A1 is between 81-100 I want it to display the word
Distinction in B1. I am sure someone would know how to do this!!! Please
help. You will make my life so much easier!!!
Cheers
 
K

Karen

Thank you, thank you, thank you !! Just one more question. Is there two
brackets at the end because one is for the total formula and the other is for
the formula within? So if I was to add a fail would it be
=IF(A1<50,"Fail",IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction")))
If this is right, you are a really good teacher!!!!
Thanks again
 
G

Gary''s Student

Your formula is correct if you want "Fail" to be between 0 and 49.

If you want "Fail" to be between 0 and 50 then change your formula to:

=IF(A1<51,"Fail",IF(A1<61,"Pass",IF(A1<81,"Credit","Distinction")))

Have a pleasant day !
 
Top