Im trying to create a calculator in excel that can do the following:
Take the first $250 of your final value and multiply it by 6%. If your item sold for $250 or less this is the final value.
If your final value was more than $250, take the additional amount over $250 and multiply it by 3.5%.
Add up these amounts and that is the final value.
For example, a $1500 item would cost:
$250 times 6% = $15.00
$1250 times 3.5% = $43.75
Total = $58.75
A $500 item would cost:
$250 times 6% = $15.00
$250 times 3.5% = $8.75
Total = $23.75
Bookmarks