Advanced Excel Questions

massahwahl

massahwahl

VIP Member
Im using Excel 200 just as a reference...

Ive made a spreadsheet to use with ebay to determine final gain of an item once Ive sold it. I use it while im at the store, so if i see a good bargain, I can quickly determine what i will make off of buying it cheap and reselling it. So here is how I have the spreadsheet laid out right now:

untitled-1.jpg


I have the autosum set so that cells in columns B, D, E, F, G, and H auto add themselves into cell I to give me my total.

What I need to do still is figure out a way to auto calculate ebay and paypal fees based on the amount that is plugged into cells C and D. Ebay charges by how much an auction starts for, and how much the item actualy sells for. Paypal charges by the amount transfered into your account from another member.

The Ebay price tier can be found here: http://pages.ebay.com/help/sell/fees.html

So how do I tell excel to add the correct amounts based on what number is inputed into cells C and D.

If any of this is not making sense, let me know and I will try to clear it up. Thanks!
 
I'm a self-proclaimed demigod with making super-complex stuff in Excel super easy to read/use. If you'd like to send it my way, I can take a look and either offer suggestions or tweak it a bit if you'd like. I'm not certain when I'll have time to look at it, but I will ASAP!
 
Well all the info is stated, I just need to know how to write an equation that says 'If x amount equals an amount greater than Y but less than T add R amount to I4'
 
Nested IF statements is what you will need to calculate the fee structure. Copy and paste the below statement into cell F4.

=IF(C4>500,4.8,IF(C4>200,3.6,IF(C4>50,2.4,IF(C4>25,1.2,IF(C4>10,0.6,IF(C4>1,0.4,0.2))))))+IF(D4>1000,(1.31+31.69+0.015*(D4-1000.01)),IF(D4>25,(1.31+0.0325*(D4-25.01)),IF(D4>0.01,0.0525*D4,0)))
 
Alright I wrote this simple If statement:

=IF(C5<10,(C5+0.4),(C5+0.6))

This tells excel if the starting price of an item less than $10, add 40 cents to the price in the ebay fees cell, but if its above $10, add 60 cents. This works, but obviously there are different tiers for pricing. Can I write a similar statement for each tier? but instead of the second argument just leave it as C5?
 
I do it so much I really don't want to look at cosine's nested statement, but he has the right idea.
 
Yes. Search If statements in the help search command within excel, this should help you allot. Also, try looking at excel loops and if statements online on other sites to assist you. GL
 
Cosine has it... I was about to write it, thx for getting me out of it.

You dont have to finish the IF statement there, for example =IF(AND(A1>1,A1<5),"Tier1",IF(AND(A1>5,A1<10),"Tier2",....
Where the function finishes and you can put the if true or false you can write another if statement. So if A1 is between 1 and 5 it will answer Tier1, if not it will do the next IF statement... You can keep it going for a while...
 
Last edited:
Nevermind, its correct, its just showing a crazy amount of decimal places. Fixed it by assigning the Currency to that column
 
Last edited:
Once I write the statement to figure out paypal fees, I will post the final Spreadsheet. VERY useful for people that do a lot of ebaying like I do.
 
You must log in or register to reply here.
Back
Top