Thread
:
Round price to end in .99
View Single Post
#
3
Posted to microsoft.public.excel.misc
Jeff
external usenet poster
Posts: 921
Round price to end in .99
How about =round(price,0)-.01
"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?
Reply With Quote
Jeff
View Public Profile
Find all posts by Jeff