ExcelBanter - Mround to nearest 5 c

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Mround to nearest 5 c (https://www.excelbanter.com/excel-discussion-misc-queries/33764-mround-nearest-5-c.html)

Giorgos

Mround to nearest 5 c

I Have tried The function MROUND To Round To Nearest 5 Cents But it erases My
Formulars in the Cells wihich is rounded
any Other Sugestions

Bob Phillips

Is there a reason to use MROUND?

=ROUND(A20*20,0)/20

works fine.

--
HTH

Bob Phillips

"Giorgos" wrote in message
...
I Have tried The function MROUND To Round To Nearest 5 Cents But it erases
My
Formulars in the Cells wihich is rounded
any Other Sugestions

All times are GMT +1. The time now is 05:37 PM.