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 up?

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


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Fri Feb 25, 2005 5:39 pm    Post subject: Rounding up? Reply with quote

This is probably so simple I'm embarrassed to ask, but here goes anyway:

How do I round up o the next integer? I am keeping a list of phone calls incurred for work, and my phone company charges in whole minutes. I have a psreadsheet in which I am listing the actual duration of each call, but to calculate running expenses, I need to tally the calls as whole minutes. So, for example, if cell J2 has 121 in it (the number of seconds the call took), I can enter =(j2/60) in K2 to get the duration expressed in minutes, but I need that result rounded up to 3.0 What's the syntax for this? Thanks.
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
David
Super User
Super User


Joined: 24 Oct 2003
Posts: 5668
Location: Canada

PostPosted: Fri Feb 25, 2005 8:15 pm    Post subject: Re: Rounding up? Reply with quote

maxqnz wrote:
This is probably so simple I'm embarrassed to ask, but here goes anyway:

How do I round up o the next integer? I am keeping a list of phone calls incurred for work, and my phone company charges in whole minutes. I have a psreadsheet in which I am listing the actual duration of each call, but to calculate running expenses, I need to tally the calls as whole minutes. So, for example, if cell J2 has 121 in it (the number of seconds the call took), I can enter =(j2/60) in K2 to get the duration expressed in minutes, but I need that result rounded up to 3.0 What's the syntax for this? Thanks.


From the Help file:

ROUNDUP
Rounds a number up, according to the specified decimal place.
Syntax:
ROUNDUP(number; count)
number is the number to be rounded up.
count (optional) is the number of digits to which rounding up is to be done.
Example:
Entering the value 123.343 and the value 2 in the count field will return the value 123.35.

David.
Back to top
View user's profile Send private message
maxqnz
Super User
Super User


Joined: 24 Mar 2003
Posts: 1290
Location: Te Ika a Maui, Aotearoa

PostPosted: Fri Feb 25, 2005 11:17 pm    Post subject: Reply with quote

Thanks, David. It turns out the answer was simply nothing - putting "0" in as the count number. So, roundup(2.02,0) returns 3. Much obliged.
_________________
Noho ora mai, ka kite ano.
What Is A Pieriansipist?

OOo 2.4/XP Pro SP2 / OOo 2.3.0.1/OpenSuse 10.3
Back to top
View user's profile Send private message Visit poster's website
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