percentage computation

E

Excel

hi i have this Data with below 50% average is the passing grades and above
50% is failure average. my question is i need to have it converted in the
normal grading system where 100% is the passing grades is there a way i could
have this calc.

THANKS
 
M

MikeJohnB

Like Mike H, I am not sure if I have what you are trying to worked out but:

Say your results are in cell A1 through A10 should the result be as indicated?
A B
50 100
49 98
52 104
56 112
45 90
44 88
55 110
51 102
45 90
58 116

The way this is derived, the formulae in Cells B

=A1/50*100
=A2/50*100
etc

Copy down

I think this is probably too simple a solution and you mean something
entirely different???

However, does this answer your question???

Kindest Regards

Mike B
 
Top