Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Jan 13, 2009, 04:55 PM   #1
Revival Cr8tive
macrumors member
 
Join Date: Jan 2009
Numbers '09 Tax Formular help?

Does anyone know how to set a Formula in Numbers '09 so that 20% can be found of a total amount?

In the UK we have to pay 20% as Tax and I want to know if it can worked out by Numbers automatically. It seems quite an important function, as most people pay Tax, so I carn't understand why its so hard to work out.

Any help would be GREAT! :-)

Thanks.
Revival Cr8tive is offline   0 Reply With Quote
Old Jan 13, 2009, 04:57 PM   #2
swiftaw
macrumors 603
 
swiftaw's Avatar
 
Join Date: Jan 2005
Location: Omaha, NE, USA
Yes

just type =0.2*Cell in whichever cell you want the answer in.

where Cell is the reference to whatever Cell contains your total.
swiftaw is offline   0 Reply With Quote
Old Jan 13, 2009, 05:01 PM   #3
Revival Cr8tive
Thread Starter
macrumors member
 
Join Date: Jan 2009
Error...

Quote:
Originally Posted by swiftaw View Post
Yes

just type =0.2*Cell in whichever cell you want the answer in.

where Cell is the reference to whatever Cell contains your total.
Thanks for the swift reply.

Sadly though I get an error message in the cell "Formula contains Syntax Error"

Any suggestions?

Thanks.
Revival Cr8tive is offline   0 Reply With Quote
Old Jan 13, 2009, 05:04 PM   #4
swiftaw
macrumors 603
 
swiftaw's Avatar
 
Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
Originally Posted by Revival Cr8tive View Post
Thanks for the swift reply.

Sadly though I get an error message in the cell "Formula contains Syntax Error"

Any suggestions?

Thanks.
What exactly did you type?
swiftaw is offline   0 Reply With Quote
Old Jan 13, 2009, 05:10 PM   #5
Revival Cr8tive
Thread Starter
macrumors member
 
Join Date: Jan 2009
Quote:
Originally Posted by swiftaw View Post
What exactly did you type?
0.2* in the formula function box
Revival Cr8tive is offline   0 Reply With Quote
Old Jan 13, 2009, 05:11 PM   #6
swiftaw
macrumors 603
 
swiftaw's Avatar
 
Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
Originally Posted by Revival Cr8tive View Post
0.2* in the formula function box
Ok, suppose that you have you Total in cell A1, and you want to put 20% of that total in A2, so you would highlight A2 and then in the formula box type

=0.2*A1
swiftaw is offline   0 Reply With Quote
Old Jan 13, 2009, 05:23 PM   #7
Revival Cr8tive
Thread Starter
macrumors member
 
Join Date: Jan 2009
Quote:
Originally Posted by swiftaw View Post
Ok, suppose that you have you Total in cell A1, and you want to put 20% of that total in A2, so you would highlight A2 and then in the formula box type

=0.2*A1

Yep! Got it. Thanks. I'm a total novice at Numbers and Spreadsheets. Really hepful. Thankyou.

However when I changed the cells I wanted displayed in my pie chart, it says that 17% rather than 20%? Does that make sense?
Thanks though!
Revival Cr8tive is offline   0 Reply With Quote
Old Jan 13, 2009, 05:25 PM   #8
swiftaw
macrumors 603
 
swiftaw's Avatar
 
Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
Originally Posted by Revival Cr8tive View Post
Yep! Got it. Thanks. I'm a total novice at Numbers and Spreadsheets. Really hepful. Thankyou.

However when I changed the cells I wanted displayed in my pie chart, it says that 17% rather than 20%? Does that make sense?
Thanks though!
Without seeing your spreadsheet I cant really determine what it is displaying and whether it's correct.
swiftaw is offline   0 Reply With Quote
Old Jan 13, 2009, 05:28 PM   #9
Revival Cr8tive
Thread Starter
macrumors member
 
Join Date: Jan 2009
No worries. I can live with it.

I worked it out and its to the right amount irrespective of the pie chart.

Thanks a bunch!

Revival Cr8tive is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
How do you find out if Apple Tv will be tax exempt during your states tax exempt days Zellio Apple TV and Home Theater 3 Aug 10, 2013 01:08 AM
Apple Paid $6 Billion in Federal Income Tax in 2012, 1/40 of All U.S. Corporate Income Tax Collected MacRumors Politics, Religion, Social Issues 367 Feb 6, 2013 01:21 PM
Apple is example of broken system: Low tax only work if tax-investment cycle operates katewes Politics, Religion, Social Issues 8 Dec 31, 2012 12:15 AM

Forum Jump

All times are GMT -5. The time now is 05:21 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC