Calculation for Ebay worksheet.

[greggin via OfficeKB.com]

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

 

[Guest]

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

where A1 holds the final bid

Regards,

Peo Sjoblom

 

[N Harkawat]

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

 

[greggin via OfficeKB.com]

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