Calculation for Ebay worksheet.
 

I don't know if this Calculation can be done. It's the final value fee for
ebay auctions. The FVF is 5.25% of the closing bid if your item sells for
less than 25.00. If your item sells for more than 25.00 the FVF is an
additional 2.75% of only the difference in addition to the original 5.25%.
Thank you in advance if you can figure this out.
Greggin

=IF(A125,(25*5.25%)+((A1-25)*2.75%),A1*5.25%)

where A1 holds the final bid

Regards,

Peo Sjoblom

"greggin via OfficeKB.com" wrote:

I don't know if this Calculation can be done. It's the final value fee for
ebay auctions. The FVF is 5.25% of the closing bid if your item sells for
less than 25.00. If your item sells for more than 25.00 the FVF is an
additional 2.75% of only the difference in addition to the original 5.25%.
Thank you in advance if you can figure this out.
Greggin

=MIN(24.99,A1)*5.25%+MAX(0,A1-24.99)*5.75%
where A1 is the closing bid

"greggin via OfficeKB.com" wrote in message
...
I don't know if this Calculation can be done. It's the final value fee for
ebay auctions. The FVF is 5.25% of the closing bid if your item sells for
less than 25.00. If your item sells for more than 25.00 the FVF is an
additional 2.75% of only the difference in addition to the original 5.25%.
Thank you in advance if you can figure this out.
Greggin

Thanks so much for your help. I tried it and it works just right.