how to rounda decimal up to #.#9

T

Tobzcpa

I m trying to round a decimal up to the #.#9. For example 8.33 I would
like to round up to 8.39 or 9.95 to round up to 9.99. Does anyone know
the formula to do this. If so email me @ [email protected]
Thanks
 
B

Bob Phillips

=ROUNDUP(A2,1)-0.01

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
H

Harlan Grove

Bob Phillips said:
=ROUNDUP(A2,1)-0.01
Click to expand...
....

Boundary conditions are a PITA!

=ROUNDUP(9.00,1)-0.01

evaluates to 8.99. If the OP would want 9.09, then change the formula to

=ROUNDDOWN(A1+0.1,1)-0.01
 
B

Bob Phillips

I seem to recall you telling me that before <vbg>.

Good point though.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
Top