Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


CdTDroiD

869 posts

Ultimate Geek

Trusted

#86437 6-Jul-2011 21:21
Send private message

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+

Create new topic
alasta
6687 posts

Uber Geek

Trusted
Subscriber

  #490273 6-Jul-2011 21:25
Send private message

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

Trusted

  #490274 6-Jul-2011 21:27
Send private message

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
6687 posts

Uber Geek

Trusted
Subscriber

  #490283 6-Jul-2011 21:38
Send private message

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

Trusted

  #490289 6-Jul-2011 21:41
Send private message

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
1426 posts

Uber Geek


  #490351 6-Jul-2011 23:22
Send private message

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 ! 




gz ftw


Kraven
729 posts

Ultimate Geek


  #490368 6-Jul-2011 23:52
Send private message

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

Create new topic





News and reviews »

Amazfit Expands Active 2 Lineup with the New Active 2 Square
Posted 23-Jun-2025 14:49


Logitech G522 Gaming Headset Review
Posted 18-Jun-2025 17:00


Māori Artists Launch Design Collection with Cricut ahead of Matariki Day
Posted 15-Jun-2025 11:19


LG Launches Upgraded webOS Hub With Advanced AI
Posted 15-Jun-2025 11:13


One NZ Satellite IoT goes live for customers
Posted 15-Jun-2025 11:10


Bolt Launches in New Zealand
Posted 11-Jun-2025 00:00


Suunto Run Review
Posted 10-Jun-2025 10:44


Freeview Satellite TV Brings HD Viewing to More New Zealanders
Posted 5-Jun-2025 11:50


HP OmniBook Ultra Flip 14-inch Review
Posted 3-Jun-2025 14:40


Flip Phones Are Back as HMD Reimagines an Iconic Style
Posted 30-May-2025 17:06


Hundreds of School Students Receive Laptops Through Spark Partnership With Quadrent's Green Lease
Posted 30-May-2025 16:57


AI Report Reveals Trust Is Key to Unlocking Its Potential in Aotearoa
Posted 30-May-2025 16:55


Galaxy Tab S10 FE Series Brings Intelligent Experiences to the Forefront with Premium, Versatile Design
Posted 30-May-2025 16:14


New OPPO Watch X2 Launches in New Zealand
Posted 29-May-2025 16:08


Synology Premiers a New Lineup of Advanced Data Management Solutions
Posted 29-May-2025 16:04









Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.



Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.