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

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

Get help with Android from a XDA Recognized Developer - Google+

## alasta

6238 posts

Uber Geek

Trusted
Subscriber

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

## Mighty Ape

Shop Mighty Ape for electronics, games, computers books and more (affiliate link).

## CdTDroiD

869 posts

Ultimate Geek

Trusted

#490274 6-Jul-2011 21:27

I tried that and it doesnt seem to work

Im trying to put this:

in excel

Get help with Android from a XDA Recognized Developer - Google+

## alasta

6238 posts

Uber Geek

Trusted
Subscriber

#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

Trusted

#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

Get help with Android from a XDA Recognized Developer - Google+

## b0untypure1

1425 posts

Uber Geek

#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

710 posts

Ultimate Geek

#490368 6-Jul-2011 23:52

Here, someone has already done it for you:

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

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.