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
6238 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. 

 
 
 

Shop Mighty Ape for electronics, games, computers books and more (affiliate link).
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
6238 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
1425 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
710 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 »

New Air Traffic Management Platform and Resilient Buildings a Milestone for Airways
Posted 6-Dec-2023 05:00


Logitech G Launches New Flagship Console Wireless Gaming Headset Astro A50 X
Posted 5-Dec-2023 21:00


NordVPN Helps Users Protect Themselves From Vulnerable Apps
Posted 5-Dec-2023 14:27


First-of-its-Kind Flight Trials Integrate Uncrewed Aircraft Into Controlled Airspace
Posted 5-Dec-2023 13:59


Prodigi Technology Services Announces Strategic Acquisition of Conex
Posted 4-Dec-2023 09:33


Samsung Announces Galaxy AI
Posted 28-Nov-2023 14:48


Epson Launches EH-LS650 Ultra Short Throw Smart Streaming Laser Projector
Posted 28-Nov-2023 14:38


Fitbit Charge 6 Review 
Posted 27-Nov-2023 16:21


Cisco Launches New Research Highlighting Gap in Preparedness for AI
Posted 23-Nov-2023 15:50


Seagate Takes Block Storage System to New Heights Reaching 2.5 PB
Posted 23-Nov-2023 15:45


Seagate Nytro 4350 NVMe SSD Delivers Consistent Application Performance and High QoS to Data Centers
Posted 23-Nov-2023 15:38


Amazon Fire TV Stick 4k Max (2nd Generation) Review
Posted 14-Nov-2023 16:17


Over half of New Zealand adults surveyed concerned about AI shopping scams
Posted 3-Nov-2023 10:42


Super Mario Bros. Wonder Launches on Nintendo Switch
Posted 24-Oct-2023 10:56


Google Releases Nest WiFi Pro in New Zealand
Posted 24-Oct-2023 10:18









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.







GoodSync is the easiest file sync and backup for Windows and Mac