Round price to end in .99

[Chip]

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?

 

[David]

try =roundup(a1,0)-.01
assuming data to round is in cell a1

 

[Jeff]

How about =round(price,0)-.01

 

[Lars-Åke Aspelin]

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?

Try this formula:

=ROUNDUP(A1,0)-0.01

Hope this helps / Lars-Åke

 

[Chip]

Thanks.....it worked just as requested. I appreciate your help.

 

[Dave Peterson]

Check your other post.

I want to raise prices by 5% and have the resulting price end in xxxx.99.
For example, my resulting price would be $15.67, I want the result to
actually be $15.99. Any help?