MacRumors Forums Numbers '09 Tax Formular help?
 User Name Remember Me? Password

 Thread Tools Search this Thread Display Modes
 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. 0
 Jan 13, 2009, 04:57 PM #2 swiftaw macrumors 603     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. 0
Jan 13, 2009, 05:01 PM   #3
Revival Cr8tive
Thread Starter
macrumors member

Join Date: Jan 2009
Error...

Quote:
 Originally Posted by swiftaw 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.
0
Jan 13, 2009, 05:04 PM   #4
swiftaw
macrumors 603

Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
 Originally Posted by Revival Cr8tive 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?
0
Jan 13, 2009, 05:10 PM   #5
Revival Cr8tive
Thread Starter
macrumors member

Join Date: Jan 2009
Quote:
 Originally Posted by swiftaw What exactly did you type?
0.2* in the formula function box
0
Jan 13, 2009, 05:11 PM   #6
swiftaw
macrumors 603

Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
 Originally Posted by Revival Cr8tive 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
0
Jan 13, 2009, 05:23 PM   #7
Revival Cr8tive
Thread Starter
macrumors member

Join Date: Jan 2009
Quote:
 Originally Posted by swiftaw 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!
0
Jan 13, 2009, 05:25 PM   #8
swiftaw
macrumors 603

Join Date: Jan 2005
Location: Omaha, NE, USA
Quote:
 Originally Posted by Revival Cr8tive 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.
0
 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! 0

 Thread Tools Search this Thread Search this Thread: Advanced Search Display Modes Linear Mode

 Similar Threads thread Thread Starter Forum Replies Last Post Zellio Apple TV and Home Theater 3 Aug 10, 2013 01:08 AM MacRumors Politics, Religion, Social Issues 367 Feb 6, 2013 01:21 PM katewes Politics, Religion, Social Issues 8 Dec 31, 2012 12:15 AM

 Forum Jump User Control Panel Private Messages Subscriptions Who's Online Search Forums Forums Home News and Article Discussion     MacRumors.com News Discussion     Mac Blog Discussion     iOS Blog Discussion iPhone, iPod, iPad, Apple Watch     iOS         iOS 8         iOS 7         iOS 6         iOS 5 and earlier         Jailbreaks and iOS Hacks     iPhone         iPhone Tips, Help and Troubleshooting         iPhone Accessories         iPhone Launch Meetups         iPhone Wallpapers etc.         iPhone Apps     iPad         iPad Tips, Help and Troubleshooting         iPad Accessories         iPad Launch Meetups         iPad Wallpapers etc.         iPad Apps     iPod touch         iPod touch Hacks         iPod touch Accessories         iPod touch Apps     iPod     Apple Watch         Apple Watch Accessories         Apple Watch Apps     Alternatives to iOS and iOS Devices Apple Applications     iPhone and iPod touch Apps     iPad Apps     Apple Watch Apps     Mac Applications and Mac App Store Apple Hardware     Desktops         iMac         Mac Pro         Mac mini     Notebooks         MacBook         MacBook Pro         MacBook Air     PowerPC Macs     Apple TV and Home Theater     Mac Peripherals     Buying Tips and Advice Apple Systems and Services     Mac Basics and Help     OS X         OS X Yosemite (10.10)         OS X Mavericks (10.9)         OS X 10.8 Mountain Lion         Mac OS X 10.7 Lion         Mac OS X Server, Xserve, and Networking     iCloud and Apple Services     Windows, Linux & Others on the Mac     Programming         iPhone/iPad Programming         Mac Programming         App Store Business, Legal and Marketıng Special Interests     Mac and PC Games         Console Games     Digital Audio     Visual Media         Design and Graphics         Digital Photography         Digital Video         Web Design and Development     Apple Collectors     Distributed Computing Mac Community     Community Discussion         Apple, Industry and Internet Discussion         Current Events         Politics, Religion, Social Issues     Picture Gallery         UI Customization     Site and Forum Feedback         Mac Guides Private Forums Archive     Wasteland     Archives of Old Posts         MacRumors News Discussion (archive)         MacBytes.com News Discussion         Buying Tips, Advice and Discussion (archive)         Community         Daily Tunes Site Discussion and Feedback         Event Archives             Macworld San Francisco 2008         Games         General Mac Discussion         Hardware Rumors         iPhone Purchaser Meetups         Leopard Event Meetups         Mac Help/Tips         Mac OS X 10.3 (Panther) Discussion         Mac Scene         Macintosh Computers         MacRumors Old Skool         Marketplace Archive 1 (Posts count)         Marketplace Archive 2             iPhone Marketplace Archive         Music Discussion         New Mac Application Announcements         Product Recommendations/Reviews         Site News         Switch Stories         Web Design and Development (archive)         Past Contests             1,000,000 Post Contest             2,000,000 Post Contest             3,000,000 Post Contest             4,000,000 Post Contest             5,000,000 Post Contest             Ten Million Post Contest

All times are GMT -5. The time now is 01:21 AM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps
 Contact Us - MacRumors Forums - Archive - Privacy Statement / DMCA Agent - Top

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