Mround to nearest 5 c

Giorgos · Jul 5, 2005

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 · Jul 5, 2005

Is there a reason to use MROUND?

=ROUND(A20*20,0)/20

works fine.