how to rounda decimal up to #.#9

[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 @ (e-mail address removed)
Thanks

 

[Bob Phillips]

=ROUNDUP(A2,1)-0.01

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Harlan Grove]

=ROUNDUP(A2,1)-0.01

....

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

 

[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)