
1. Re: How to round a number to the nearest hundredth higher ?
philmcgeehan Nov 12, 2015 5:48 AM (in response to ingrid.sO1)ceiling ( 14.12235 * 100 ) / 100

2. Re: How to round a number to the nearest hundredth higher ?
TomHays Nov 12, 2015 5:50 AM (in response to ingrid.sO1)Add 5/1000 to the number before rounding.
Round(theNumber + .005; 2)
Tom

3. Re: How to round a number to the nearest hundredth higher ?
philmcgeehan Nov 12, 2015 5:56 AM (in response to TomHays)If you use the round method it will round 14.12000 to 14.13000.
The ceiling method would keep it at 14.12

4. Re: How to round a number to the nearest hundredth higher ?
ingrid.sO1 Nov 12, 2015 6:21 AM (in response to TomHays)Thank you very much !!
Finally, i've used this one > Round(theNumber + .01; 2) < because, the other one didn't give me the right total amount (it is for a bill).
Ingrid

5. Re: How to round a number to the nearest hundredth higher ?
TomHays Nov 12, 2015 6:23 AM (in response to philmcgeehan)True.
The "round to the nearest hundredth higher" is somewhat ambiguous for what to do with numbers that have no digits in the thousands and smaller.
If no rounding is needed in those cases, something like
Round (theNumber + 0.004999999999999; 2) would address the issue in some fashion but is subject to a floating point roundoff error.
An alternative is to use a Case() and detect if the number does not need to be rounded (has nothing in thousands or smaller) and only use Round() if necessary.
Considering the needed workarounds, Ceiling is a more elegant method.