View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
Posts: 3,572
Default Rounding up or down to the nearest $.09

Try this:




================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"Sandy G." wrote in message
I am new to the retail biz, and have encountered a challenge that I have
unable to write the correct formula for, which is: How do you get a
value to round up or down to the nearest $.09? This is a pricing strategy
that we employ, and given the volume of items that our store carries, it
would be a great time saver to automate this pricing strategy. Any
assistance from the Excel gurus would be much appreciated!
Sandy G.
Finance Manager
Ever''man Natural Foods Co-op