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

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



"Excel" wrote:


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

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

--
Advice to Posters.
Check your post for replies or request for more information.
Consider providing some feed back to the response you have recieved.
Kindest Regards Mike B


"Mike H" wrote:

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



"Excel" wrote:


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