Retail Pricing

  • Thread starter Thread starter kapper
  • Start date Start date
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!
 
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)
 
This formula works as well:
=ROUNDDOWN(A1,0)-0.01
.... where A1 holds the 2.01 entry.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel formulas 2
Percentage Increase Tables 6
Apple's price hike 7
Rounding up or down to the nearest $.09 3
requiring column entries 1
Creative iRoar 0
Formula for worksheet that's tallying and pricing 5
inventory Add, Cost, Sold, Sold price - formula 3

Back
Top