Need help with formula to round (always round up) pricing to the next $9.99.

So,

9.99 stays as 9.99 and 10 becomes 19.99. try this

=CEILING(A1+0.01,10)-0.01

Mike

"EFF" wrote:

Need help with formula to round (always round up) pricing to the next $9.99.

EFF wrote:
Need help with formula to round (always round up) pricing to the next $9.99.


=ROUNDUP(A1+0.01,-1)-0.01

This assumes you want $100.00 to round up to $109.99 and not down to $99.99. If
that's wrong, drop the first "0.01".

Try:

=MAX(CEILING(A1,10)-0.01,0)

or:

=IF(OR(A1={0,""}),"",CEILING(A1,10)-0.01)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"EFF" wrote in message
...
Need help with formula to round (always round up) pricing to the next
$9.99.

Hello

Try =ROUNDUP(A1,-1)-0.01

Regards
farid2001

"EFF" wrote:

Need help with formula to round (always round up) pricing to the next $9.99.