formulas

  • Thread starter Thread starter Bacchus
  • Start date Start date
B

Bacchus

Can someone please help me with these 2 formulas that I need to enter into
my Spreadsheet?. I am trying to set up a Profit calculator for my Ebay
listings. This would be appreciated

thanks so much


Selling Price - US$25.01 - US$100.00

10.00% of the initial US$25.00 (US$2.50), plus 7.00% of the remaining
closing value balance


Selling Price - US$100.01 - US$1,000.00

10.00% of the initial US$25.00 (US$2.50), plus 7.00% of the initial
US$25.01 - US$100.00 (US$5.25), plus 5.00% of the remaining closing value
balance US$100.01 - US$1,000.00
 
Can someone please help me with these 2 formulas that I need to enter into
my Spreadsheet?
Click to expand...

One formula should suffice, namely:

=ROUND(10%*A1 - 3%*MAX(0,A1-25) - 2%*MAX(0,A1-100), 2)

-----
 
Back
Top