Formula to convert percentage final grade to 0-20 grade?
Does any one know a formula to convert the final grade column, in percentage (from 0-100%), in a 0-20 value, automatically?
Thank you so much,
Helena
iMac (Retina 5K, 27-inch, Late 2014)
Question marked as
Best reply
Hi ahgracio,
Column B formatted as %
Column C formatted as Number.
Formula in C2 (and Fill Down)
=B2×100÷5
Simplifies to =B2×20
Regards,
Ian.