how to rounda decimal up to #.#9

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tobzcpa - 16 Dec 2005 16:47 GMT

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 @ tswango@glessnercpa.com
Thanks

Signature

Tobzcpa

Reply to this Message

Bob Phillips - 16 Dec 2005 17:02 GMT

=ROUNDUP(A2,1)-0.01

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> 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 @ tswango@glessnercpa.com
> Thanks

Reply to this Message

Harlan Grove - 16 Dec 2005 17:22 GMT

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote...

>=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

Reply to this Message

Bob Phillips - 16 Dec 2005 17:47 GMT

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

Good point though.

Signature

HTH

Bob Phillips

(remove nothere from email address if mailing direct)

> "Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote...
> >=ROUNDUP(A2,1)-0.01
[quoted text clipped - 7 lines]
>
> =ROUNDDOWN(A1+0.1,1)-0.01

Reply to this Message