Rounding up or down to the nearest $.09
Try this:
=Round(A1+.01,1)-.01
--
HTH,
RD
================================================== ===
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
been
unable to write the correct formula for, which is: How do you get a
currency
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
|