One example I can perhaps think of would be in doing some statistics work?
Where you want to take values and round them up to certain grouping levels?
With use of various negative values, you can round 1.99999 up to 10, 100,
1000, 10000, etc. But it probably isn't a great demand for that kind of
thing - but then I'm not in stats field, so I could be wrong? Might be a big
demand for it in some areas of endeavor somewhere??

"Epinn" wrote:

I read Help before I post.

=ROUNDUP(11.99999,-1) yields 20

I can understand this.

=ROUNDUP(1.99999,-1) yields 10

I have a hard time accepting this regardless of whether this is logical. I prefer an error returned. Maybe for a case like this, we need to do a logical test first for the number of decimal places available to the left of the decimal point? Any comments?

Can someone give me a good example where we will use -1 with ROUNDUP?

Thanks.

Epinn