Rounding Up

[EFF]

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

 

[Mike H]

So,

9.99 stays as 9.99 and 10 becomes 19.99. try this

=CEILING(A1+0.01,10)-0.01

Mike

 

[Glenn]

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".

 

[Sandy Mann]

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

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk

 

[farid2001]

Hello

Try =ROUNDUP(A1,-1)-0.01

Regards
farid2001