OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

Rounding to nearest five cents. [SOLVED]

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc
View previous topic :: View next topic  
Author Message
Jezzta667
General User
General User


Joined: 08 Feb 2012
Posts: 39

PostPosted: Wed May 16, 2012 11:13 pm    Post subject: Rounding to nearest five cents. [SOLVED] Reply with quote

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
View user's profile Send private message Send e-mail
Robert Tucker
Moderator
Moderator


Joined: 16 Aug 2004
Posts: 3407
Location: Manchester UK

PostPosted: Thu May 17, 2012 12:00 am    Post subject: Reply with quote

Try:

http://www.accessanalytic.com.au/kb.php?CategoryID=11&ArticleID=10
_________________
OpenOffice 4.0.0 and LibreOffice 4.x.x on Fedora 20, Ubuntu 13.10, Windows 8.1 Preview (Triple Boot)
Back to top
View user's profile Send private message
karolus
OOo Advocate
OOo Advocate


Joined: 22 Jun 2011
Posts: 210

PostPosted: Thu May 17, 2012 12:24 am    Post subject: Reply with quote

Hi

Code:
=MROUND( A1; 0.05 )


Karo
Back to top
View user's profile Send private message
Jezzta667
General User
General User


Joined: 08 Feb 2012
Posts: 39

PostPosted: Thu May 24, 2012 7:48 pm    Post subject: Reply with quote

Thanks guys. This worked great.

Sorry for late reply.
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Calc All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group