| View previous topic :: View next topic |
| Author |
Message |
Jezzta667
General User
Joined: 08 Feb 2012
Posts: 35
|
 Posted: Wed May 16, 2012 11:13 pm Post subject: Rounding to nearest five cents. [SOLVED] |
 |
|
Hey guys, sorry but I have tried searching for this and can't find anything useful.
How do I take a cell and get it to round to the nearest five cents?
eg.
$10.72 to $10.70 and $10.74 to $10.75
I'm not really fussed about which way $10.73 goes!
Thanks in advance
Last edited by Jezzta667 on Thu May 24, 2012 7:48 pm; edited 1 time in total |
|
| Back to top |
|
 |
Robert Tucker
Moderator
Joined: 16 Aug 2004
Posts: 3367
Location: Manchester UK
|
|
| Back to top |
|
|
karolus
OOo Advocate
Joined: 22 Jun 2011
Posts: 208
|
| Posted: Thu May 17, 2012 12:24 am Post subject: |
|
|
Hi
| Code: | | =MROUND( A1; 0.05 ) |
Karo |
|
| Back to top |
|
|
Jezzta667
General User
Joined: 08 Feb 2012
Posts: 35
|
| Posted: Thu May 24, 2012 7:48 pm Post subject: |
|
|
Thanks guys. This worked great.
Sorry for late reply. |
|
| Back to top |
|
|
|
