ukulele_ninja

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:



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!

__________________
Do you remember when the tigers broke free?

CF COD4: CF|UkuleleNinja

imsati

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!

__________________
--Jay
Gigabyte EP31-DS3L | E4500 | Masscool HSF paired with AS-5
80 GB SATA2 x 2 | e-GeForce 7100 GS | CM Elite 330 (gorgeous!)
Triple Boot: Ubuntu 7.10/XP Home/Kubuntu 7.10

You do realize that everytime PC eye Posts, God kicks a puppy, and every time someone takes his advice, He smothers a kitten in front of a child, right?
http://www.computerforum.com/114761-...tml#post922619

Beyond

You'll need to use an IF statement.

__________________
EVGA 680i // Antec P180B
Intel Core 2 Duo E6600
2GB Corsair XMS2 Dominator
EVGA 8800GTX > MAG 22" (x2)
Audigy 2 ZS > a) PA2V2 > Alessandro MS-1s (music); b) Pioneer VSX-516-K/S > Insignia NS-B2111 (2)
74GB WD Raptor | 500GB WD Caviar SE16
Antec TruePower 2.0

..at factory timings.

ukulele_ninja

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'

__________________
Do you remember when the tigers broke free?

CF COD4: CF|UkuleleNinja

ukulele_ninja

Im really new to the writing equations thing though, how do you use the 'If' statement?

__________________
Do you remember when the tigers broke free?

CF COD4: CF|UkuleleNinja

cosine4

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)))

ukulele_ninja

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?

__________________
Do you remember when the tigers broke free?

CF COD4: CF|UkuleleNinja

Beyond

I do it so much I really don't want to look at cosine's nested statement, but he has the right idea.

__________________
EVGA 680i // Antec P180B
Intel Core 2 Duo E6600
2GB Corsair XMS2 Dominator
EVGA 8800GTX > MAG 22" (x2)
Audigy 2 ZS > a) PA2V2 > Alessandro MS-1s (music); b) Pioneer VSX-516-K/S > Insignia NS-B2111 (2)
74GB WD Raptor | 500GB WD Caviar SE16
Antec TruePower 2.0

..at factory timings.

JLV2k5

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

__________________

Can't wait to finish college and build my system.

Trizoy

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),"Tie r2",....
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...

__________________
01100110 01100001 01110010 01110100