Round price to end in .99
try =roundup(a1,0)-.01
assuming data to round is in cell a1
"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?
|