Round price to end in .99
Thanks.....it worked just as requested. I appreciate your help.
"Lars-Åke Aspelin" wrote:
On Mon, 17 Aug 2009 13:18:01 -0700, Chip
wrote:
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
|