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