percentage computation

[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

 

[Mike H]

This isn't clear, how is Excel interpreting <50% as a pass and vice versa?

 

[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