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 off Calculations to 'preset units'

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


Joined: 17 May 2006
Posts: 9
Location: Scotland

PostPosted: Wed May 17, 2006 7:00 am    Post subject: Rounding off Calculations to 'preset units' Reply with quote

Can anyone help with this problem?

We have been using Lotus 123 for costings for many years and one of the nice things within this program is the function to round off things to a preset units.

For example. we do lots of price lists in different currencies and they all start off in UK Sterling to then be converted into EURO -US$ and Canadian$ etc.
In Lotus I can set the calculation to round off (up or down) to for example 0.1 - 0.25 - 0.5 - 1 etc which save a lot of time as we have hundreds of prices listed. The beauty with this is that we tend to set small prices to 0.10-0.25, medium prices to 0.50-1 and higher prices to 1-5-10
I can not find any way of doing it in Calc - is there one available ??? It would save us (me...) lots of 'over-typing'.

In Lotus I use this function:
example
@roundm((A2+B6), 0.1,1) where 0.1 is the unit and the 1 = rounding UP.
or
@roundm((A2/0.90),0.25,1)
_________________
Best regards
Peter
Back to top
View user's profile Send private message
Netwaves
General User
General User


Joined: 01 Aug 2005
Posts: 32
Location: Norfolk VA USA

PostPosted: Wed May 17, 2006 7:19 am    Post subject: ROUNDUP - Maybe this can help Reply with quote

ROUND
Returns a number rounded to a certain number of decimal places according to valid mathematical criteria.
Syntax:
ROUND(number; count)
number is the number to be rounded.
count (optional) is the number of the places to which the value is to be rounded. If the count parameter is negative, numbers before the decimal are rounded.
Example:
If you enter the number 17.546 in the number field, with 1 specified as the number of rounding places, 17.5 will be returned as the result.
If you enter the number -32.483 in the number field, with 3 specified as the number of rounding places, -32.48 will be returned as the result.
ROUNDDOWN
Rounds a number down, toward zero.
Syntax:
ROUNDDOWN(number; count)
number is the number to be rounded down.
count (optional) is the number of digits to be rounded down to. If the count parameter is negative, rounding is to the digits preceding the decimal point.
Example:
Entering the value 567.567 and the value 2 in the count field will return 567.56.
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.
Back to top
View user's profile Send private message Visit poster's website Yahoo Messenger
RickRandom
Super User
Super User


Joined: 27 Jan 2006
Posts: 1082
Location: UK

PostPosted: Wed May 17, 2006 8:15 am    Post subject: Reply with quote

Look at functions such as FLOOR() and CEILING(). These work with steps of 0.25 or whatever you want, for example

=FLOOR(324.567;0.25)

gives

324.5

and

=CEILING(324.567;0.25)

gives

324.75
Back to top
View user's profile Send private message
noranthon
Super User
Super User


Joined: 07 Jul 2005
Posts: 3318

PostPosted: Wed May 17, 2006 5:19 pm    Post subject: Reply with quote

The closest function to Lotus' roundm is MROUND. It can even, I've discovered, be used to round units of time.
Back to top
View user's profile Send private message
Pege63
General User
General User


Joined: 17 May 2006
Posts: 9
Location: Scotland

PostPosted: Wed Jun 14, 2006 5:12 am    Post subject: Reply with quote

RickRandom wrote:
Look at functions such as FLOOR() and CEILING(). These work with steps of 0.25 or whatever you want, for example

=FLOOR(324.567;0.25)

gives

324.5

and

=CEILING(324.567;0.25)

gives

324.75


Many thanks for the suggestion, just what I am after, will do the job and make life sooooo much easier for me. Very Happy
_________________
Best regards
Peter
Back to top
View user's profile Send private message
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