Roundup to .99 endings

Trying to get every number in an excel file to roundup for retail price points....

20.34 = 20.99
38.75 = 38.99

thanks in advance!

=roundup(a1,0)-.01

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mj99" <mj99.29rtnb_1150924816.0157@excelforum-nospam.com> wrote in message
news:mj99.29rtnb_1150924816.0157@excelforum-nospam.com...
>
> Trying to get every number in an excel file to roundup for retail price
> points....
>
> 20.34 = 20.99
> 38.75 = 38.99
>
> thanks in advance!
>
>
> --
> mj99
> ------------------------------------------------------------------------
> mj99's Profile:
http://www.excelforum.com/member.php...o&userid=35647
> View this thread: http://www.excelforum.com/showthread...hreadid=554321
>

Bob Phillips wrote:
> "mj99" <mj99.29rtnb_1150924816.0157@excelforum-nospam.com> wrote:
> > Trying to get every number in an excel file to roundup for retail price
> > points....
> > 20.34 = 20.99
> > 38.75 = 38.99
>
> =roundup(a1,0)-.01

Caveat emptor: That changes $20 to $19.99. If that is what you want,
so be it.

Perhaps

=roundup(a1+.01,0)-.01

daddylonglegs wrote:
> Perhaps
> =roundup(a1+.01,0)-.01

Killing an ant with a sledgehammer. I believe that has the same result
as INT(price) + 0.99, at least for all positive numbers (prices!).

mj99 wrote:
> Trying to get every number in an excel file to roundup for retail price
> points....
> 20.34 = 20.99
> 38.75 = 38.99

=INT(price) + 0.99

That will change $20 to $20.99. Is that what you want?