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
3 Replies
Just
=MROUND(A1,0.5)
Thank you. Today i have learned one thing in excel from you.
Dear Daniel Morris,
If your data is in A1, then use the formula in B1 and drag it down.
=ROUND(A1*2,0)/2
Change the cell references as required.
Do let me know if this is what you wanted to do.
Vijaykumar Shetye,
Spreadsheet Excellence,
Goa, India
