Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
=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 |
#3
|
|||
|
|||
=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 |
#4
|
|||
|
|||
Thanks so much for your help. I tried it and it works just right.
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
access my data from my master worksheet while calculation is don. | Excel Worksheet Functions | |||
Amortization Calculation in Excel worksheet | Excel Worksheet Functions | |||
Weekly Transaction Processing | Excel Worksheet Functions | |||
Indirect reference from one worksheet to another | Excel Worksheet Functions |