Round up price to end .99

[Chip]

I want to raise prices by 5% and then round the resulting number to end in
xxx.99. For example, if the result is $15.48, I want to round that to $
15.99. Any help?

 

[Dave Peterson]

It doesn't sound like you really want to round up--it sounds like you just want
to make sure it ends with 99 cents.

Maybe...
=int(a1*1.05)+.99

 

[Dave Peterson]

And you've got more replies at your other post, too.