Jump to content
Sign in to follow this  
dtrots

Round Function

Recommended Posts

I am writing a estimating table and want to have an option to round "up" the total to the nearest dollar, ten dollars, hundred dollars etc. The problem is the round function rounds up or down depending on the cutoff, not always up. I know about the "ceiling" and "floor" functions but need to round 'Up' past the decimal point.I don't want the total to be $12,400 where the round function will make it $12,000. I want to go up to $13,000.

Has anyone solved this before? Thanks in advance.

Share this post


Link to post
Share on other sites

Do you mean you want to round up to the nearest thousand?

Share this post


Link to post
Share on other sites

Well, I wrote different scripts to do different things. Example: round to nearest tens, hundreds, etc.

The problem is I need it to round up everytime.

Share this post


Link to post
Share on other sites

Ah, okay - you want a generic one. Try:

Ceiling ( number * 10^precision ) * 10^-precision

This works similar to the Round() function, with two parameters.

Share this post


Link to post
Share on other sites

To round up to the nearest cent, use a precision of 2:

Ceiling ( 1111.111 * 10^2 ) * 10^-2

returns 1111.12.

To round up to the nearest hundred, use a precision of -2:

Ceiling ( 1111.111 * 10^-2 ) * 10^2

returns 1200.

To round up to the nearest thousand, use a precision of -3:

Ceiling ( 1111.111 * 10^-3 ) * 10^3

returns 2000. And so on.

Share this post


Link to post
Share on other sites

Hi Michael,

Correct me if I am wrong here, but it doesnt seem consistant on both sides of the deciaml if the user puts in a precision that expands beyond the original number.

Perhaps this slight modification will make it more consistent?


Let ( [ e = Floor ( Log ( number ) ); 

        p = Case ( precision < -1 * e; -e; precision )

        ];

              SetPrecision ( Ceiling ( number * 10^p ) * 10^-p ; p )

       )



Share this post


Link to post
Share on other sites

-4 will give you 10,000

+4 will give you 1111.111

Its not really a problem so much but I am not sure that it really should expand beyond the current precison of the highest placed digit.

Share this post


Link to post
Share on other sites

-4 will give you 10,000

+4 will give you 1111.111

Aren't these results correct? Even 0.01 rounded up to the nearest 10,000 should return 10,000 IMHO.

Share this post


Link to post
Share on other sites

Perhaps. Mathematically, you are of course correct, but I am not sure if that would translate well for end users. I was just seemed weird. lol.

Share this post


Link to post
Share on other sites

Perhaps it seems weird to you because you are looking at the way the numbers are written, instead of their underlying values? I think of rounding as dividing the continuum of values into discrete ranges; anything within a range is converted to a boundary value.

Certainly, in some circumstances it makes sense to round to the nearest order of magnitude - but then there should be no need for a precision parameter, I think.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.