# Numbers '09 Tax Formular help?

Discussion in 'Mac Apps and Mac App Store' started by Revival Cr8tive, Jan 13, 2009.

1. ### Revival Cr8tive macrumors member

Joined:
Jan 2, 2009
#1
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.

2. ### swiftaw macrumors 603

Joined:
Jan 31, 2005
Location:
Omaha, NE, USA
#2
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.

3. ### Revival Cr8tive thread starter macrumors member

Joined:
Jan 2, 2009
#3
Error...

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

Any suggestions?

Thanks.

4. ### swiftaw macrumors 603

Joined:
Jan 31, 2005
Location:
Omaha, NE, USA
#4
What exactly did you type?

5. ### Revival Cr8tive thread starter macrumors member

Joined:
Jan 2, 2009
#5
0.2* in the formula function box

6. ### swiftaw macrumors 603

Joined:
Jan 31, 2005
Location:
Omaha, NE, USA
#6
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

7. ### Revival Cr8tive thread starter macrumors member

Joined:
Jan 2, 2009
#7

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!

8. ### swiftaw macrumors 603

Joined:
Jan 31, 2005
Location:
Omaha, NE, USA
#8
Without seeing your spreadsheet I cant really determine what it is displaying and whether it's correct.

9. ### Revival Cr8tive thread starter macrumors member

Joined:
Jan 2, 2009
#9
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!