IF Formula Excel

[geejay]

Help please. I have a list of exam marks in cells F3:F13. which require grading as follows:- <39.5 = fail, >=39.5 and <44.5 E, >=44.5 and <49.5 D, >=49.5 and <59.5 C, >=59.5 and <69.5 B, >=69.5=A . I have to enter this as an IF function but any other suggestions would be helpful. Thanks. Also Help - how do I thank people for any answers I receive?

[Dsg]

Assuming that the scores are listed in F3:F13 then if you put =IF(F3<39.5,"Fail",+H3) in cell G3 and

=IF(+F3<44.5,"Grade E",+I3) in cell H3 and

=IF(+F3<49.5,"Grade D",+J3) in cell I3 and

=IF(+F3<59.5,"Grade C",+K3) in cell J3 and

=IF(+F3<69.5,"Grade B",+L3) in cell K3 and

Grade A in cell L3

Then G3 will always show the correct grade. You can hide columns H to L for presentation.

There may be a slicker answer but this does allow you to use the function "idiot boxes".

To say thank you just post a reply to your own question.

Good Luck

[stevie21]

In whichever column you want the "FAIL", "D" etc to appear in, paste the following bumph in :
=IF(F3<39.5,"FAIL",(IF(F3<44.5,"E",(IF(F3<49.5,"D",(IF(F3<59.5,"C",IF(F3<69.5,"B","A"))))))))

Once you've done that, click the wee green tick for it to calculate that one cell. There should be a bold square round the cell that you've pasted this into - drag the bottom right corner of this cell (should have a tiny square block) down to G13 (or H13 or whichever column.13)

[geejay]

Dear DSG & Stevie21, Many thanks for your very helpful answers. You will, no doubt, have guessed that I am a computer dummie, therefore, your full explanations much appreciated. Thanks again. geejay