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

Hi Sandy,

I'd be happy to help you with this pricing strategy challenge in Excel!

To round up or down to the nearest $.09, you can use the MROUND function in Excel. Here's how:

1. First, enter the original price of the item in a cell. Let's say the price is $5.73 and the cell is A1.
2. In another cell, enter the formula "=MROUND(A1,0.09)". This formula will round the price in cell A1 to the nearest $.09.
3. The result will be $5.76, which is the rounded price.

To break down the formula a bit more, the MROUND function takes two arguments: the number you want to round, and the multiple to which you want to round. In this case, we want to round to the nearest $.09, so we use 0.09 as the second argument.

You can also use this formula to round a range of prices at once. For example, if you have a list of prices in cells A1:A10, you can enter the formula "=MROUND(A1:A10,0.09)" in cell B1 to round all the prices to the nearest $.09.

I hope this helps you automate your pricing strategy and save some time!

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

Try this out
=ROUND(A1,1)-0.01
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Sandy G." wrote:

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

=IF(A1=0,0,ROUND(A1+0.01,1)-0.01)

although I always thought retailers rounded UP?

=IF(A1=0,0,CEILING(A1,0.1)-0.01)

--


Regards,


Peo Sjoblom

"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