Forum Discussion
Rounding
Im having a mental block how to do a simple rounding to the nearest 50pence (or cents). For example I want £30.30 to be £30.50. Can someone help me please? Thank you
Just
=MROUND(A1,0.5)
Thank you. Today i have learned one thing in excel from you.
