Rounding up or down to the nearest $.09

[Sandy G.]

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!

 

[RagDyeR]

Try this:

=Round(A1+.01,1)-.01

--

HTH,

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

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!

 

[John Bundy]

Try this out
=ROUND(A1,1)-0.01

 

[Peo Sjoblom]

=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