# Macworld Forums

You need to be logged in to be able to post and reply to messages

 Got a problem? Stuck? Expert or a novice, this is the place to get your tips. Your question may already have been answered, so search this forum using a keyword from your query (eg. Router, hard disk, Safari, etc). Also, we have a list of Frequently Asked Questions, which may be the fastest route to solving your problem. Macworld Forum tips - Please read! Please also remember that when you register with the Macworld Web site in order to post on our Forums you have agreed to our Terms & Conditions and Forum Rules.
Mac help & tips
Author: Topic:  Question for mathematicians...
Wildman
Member

Posted: Fri, 06 Feb 2004 08:29PM

Hello all,

I know this is not a Mac exclusive question and I apologize in advance, but I desperately need some advice!

I need a formula for working out what the percentage of a deduction for something is, i.e "earned x amount for a job and y amount was deducted as commission" What percentage has y been calculated at?

I need to put an excell spreadsheet together ASAP!!

Many thanks,

Cheers,

Jeff

Posts: | IP: Logged
Author: Topic: Re: Question for mathematicians...
Cynic
Global Moderator

Posted: Fri, 06 Feb 2004 10:52PM

Wildman,

Well I'm no mathematician, but if you want to find out what percentage y is of x, then y divided by x multiplied by 100 gives that. E.g. x=£150 deduction y=£15 then 15/150=0.1 X 100=10%

Posts: 1665 | Location: Limbo, United Kingdom | IP: Logged
Author: Topic: Re: Question for mathematicians...
Wildman
Member

Posted: Fri, 06 Feb 2004 11:34PM

Cynic,

Just inserted that into Excell and it worked a treat! Thanks mate, much appreciated!

Alll the best,

Jeff

Posts: | IP: Logged
Author: Topic: Re: Question for mathematicians...
Cynic
Global Moderator

Posted: Sat, 07 Feb 2004 12:10AM

Wildman,

No probs.

Posts: 1665 | Location: Limbo, United Kingdom | IP: Logged
Author: Topic: Re: Question for mathematicians...
Dylanesque
Member

Posted: Sat, 07 Feb 2004 11:55AM

Cynic,

You are correct in what you say, but you need to be careful. It may be that the money Wildman received has already had the commision deducted! For example if wildman receives £y which has had a commision of £x deducted already then the percentage commission is

percentage = 100* x/(x+y)

Also if you are beginner in Excel then be careful with percentages. Probably the simplest way is just to work in fractions and then use the cell formating options (command -1) to set the number format to percentage. So, for example, if you enter 0.5 in a cell and then select the cell, type 'command-1' to format the cell, and then click on the 'number ' tab and select 'percentage from the list. The cell will then dispay as a percentage.

Happy calculations

Posts: | Location: , UK | IP: Logged
Author: Topic: Re: Question for mathematicians...
Cynic
Global Moderator

Posted: Sat, 07 Feb 2004 12:25PM

Dylanesque,

Thank you for that. As I warned, I'm no Carole Vorderman!

Right back when spreadsheets were first coming available, I did hear of a guy who mucked up the maths in a spreadsheet he used to calculate prices & was selling at less than he was buying. He only realised it when he went broke. Doh!

Posts: 1665 | Location: Limbo, United Kingdom | IP: Logged

Nokia Lumia 1520 review: Windows Phone gets better and bigger

Round-up of 4K monitors for Mac Pro

2014's 10 best cars that drive, park and even smell better than you do

What’s the best way to learn new creative skills: online or on courses?