Retail Pricing

K

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. :eek: Can this be easily done?

Thanks so much!
 
R

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)
 
D

Dave O

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

David Biddulph

Dave O said:
This formula works as well:
=ROUNDDOWN(A1,0)-0.01
... where A1 holds the 2.01 entry.
Click to expand...

Yes, providing your margins will allow you to round $2.99 down to $1.99.
 
Top