Retail Pricing

[kapper]

Hello. I will soon be calculating retail pricing. If the sum is, for example, $2.01 we need to take it down to a more acceptable retail price of $1.99. I will have a huge spreadsheet with thousands of amounts to convert. Can this be easily done?

Thanks so much!

[robert111]

calculate actual price minus integer of price

eg 1.99 minus 1 = .99
eg 2.02 minus 2 = .02

then if(difference<.05,oldprice-difference-.01, oldprice)

[Dave O]

This formula works as well:
=ROUNDDOWN(A1,0)-0.01
.... where A1 holds the 2.01 entry.

[kapper]

That'll work! Tested fine.
Thanks for your help!

[David Biddulph]

"Dave O" <[email protected]> wrote in message
news:[email protected]...
> This formula works as well:
> =ROUNDDOWN(A1,0)-0.01
> ... where A1 holds the 2.01 entry.

Yes, providing your margins will allow you to round $2.99 down to $1.99.
--
David Biddulph