Specific help with excel

Forums › Microsoft Windows › Specific help with excel

CdTDroiD

869 posts

Ultimate Geek
+1 received by user: 4

Trusted

Topic # 86437 6-Jul-2011 21:21

Hey guys i need to know how to calculate this in excel:

(amount) + $15.00 + 4.5% of Amount

So if i sold something for $300 i need to add $15.00 + 4.5% of $300

Follow me on Twitter !
Get help with Android from a XDA Recognized Developer - Google+

alasta

4058 posts

Uber Geek
+1 received by user: 713

Trusted

Subscriber

Reply # 490273 6-Jul-2011 21:25

Let's assume that your base amount (i.e. $300 in your example) is in cell A1. The formula would then be:

= A1 * 1.045 + 15

You may want to change the cell formatting to currency to make the output look tidier.

CdTDroiD

869 posts

Ultimate Geek
+1 received by user: 4

Trusted

Reply # 490274 6-Jul-2011 21:27

I tried that and it doesnt seem to work

Im trying to put this:

http://www.trademe.co.nz/Help/FeeCalculator.aspx

in excel

Follow me on Twitter !
Get help with Android from a XDA Recognized Developer - Google+

alasta

4058 posts

Uber Geek
+1 received by user: 713

Trusted

Subscriber

Reply # 490283 6-Jul-2011 21:38

When you say it "doesn't work" do you mean that it's returning an incorrect result?

The figures that are being returned by the tool that you've linked to appear to be different from the $15 + 4.5% formula that you've proposed. You need to check that your mathematical formula is correct before you turn it into an Excel formula.

CdTDroiD

869 posts

Ultimate Geek
+1 received by user: 4

Trusted

Reply # 490289 6-Jul-2011 21:41

This is copied off the site

"$200 - $1500 $15.00 + 4.5% of sale price over $200"

And yea it comes up different... i dont know why thats what i can figure out lol its like there calculator is wrong or something, i am pretty bad at math though lol

Follow me on Twitter !
Get help with Android from a XDA Recognized Developer - Google+

b0untypure1

1414 posts

Uber Geek
+1 received by user: 11

Reply # 490351 6-Jul-2011 23:22

CdTDroiD: This is copied off the site

"$200 - $1500 $15.00 + 4.5% of sale price over $200"

And yea it comes up different... i dont know why thats what i can figure out lol its like there calculator is wrong or something, i am pretty bad at math though lol

this was the 10,000th post under this category :) awesome !

Kraven

592 posts

Ultimate Geek
+1 received by user: 95

Reply # 490368 6-Jul-2011 23:52

Here, someone has already done it for you:

http://pressf1.pcworld.co.nz/showthread.php?t=111895

(Note: post is a little old and the fees have changed so you'll need to update it a little)

EDIT: Here's the edited/updated version:

=MIN(149,MAX(0.5,IF(A1<200,A1*0.075,IF(A1>1500,73.5+0.019*(A1-1500),15+0.045*(A1-200)))))