ROUNDUP and -1
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
|