| View previous topic :: View next topic |
| 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 |
|
| Back to top |
|
 |
David
Super User
Joined: 24 Oct 2003
Posts: 5668
Location: Canada
|
| 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. |
|
| Back to top |
|
|
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 |
|
| Back to top |
|
|
|
|
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
|
