[Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register]

Author Message
maxqnz
Super User

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

 Posted: Fri Feb 25, 2005 5:39 pm    Post subject: Rounding up? 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
David
Super User

Joined: 24 Oct 2003
Posts: 5668

Posted: Fri Feb 25, 2005 8:15 pm    Post subject: Re: Rounding up?

 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.
maxqnz
Super User

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

 Posted: Fri Feb 25, 2005 11:17 pm    Post subject: 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
 Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First
 All times are GMT - 8 Hours Page 1 of 1

 Jump to: Select a forum OpenOffice.org Forums----------------Setup and TroubleshootingOpenOffice.org WriterOpenOffice.org CalcOpenOffice.org ImpressOpenOffice.org DrawOpenOffice.org MathOpenOffice.org BaseOpenOffice.org Macros and APIOpenOffice.org Code Snippets Community Forums----------------General DiscussionSite Feedback
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