Your formula produce identical result as mine... thank you now I have to
options

"Peo Sjoblom" wrote:

=IF(MOD(A1,1)<0.15,FLOOR(A1,1)-0.01,ROUND(A1+0.005,1)-0.01)


--
Regards,

Peo Sjoblom



"mmmbl" wrote in message
...
I was able to put this to good use for our pricing policy but a new policy
has been adopted that .09 are no longer acceptable. If the price comes out
to
1.01 to 1.14 it should go $0.99 or $5.01 to $5.14 should be $4.99. Is
there a
way to modify the formula to apply this rule?
Thank you!

"Ron Rosenfeld" wrote:

On Thu, 7 Apr 2005 09:39:01 -0700, "David S" <David
wrote:

Want to add to what Corby wrote.
I would like the same thig, but I would like Excel to round up or down.
Example:
1.21 becomes 1.19
1.35 becomes 1.39
1.34 becomes 1.29

Perhaps:

=ROUND(A1+0.005,1)-0.01


--ron