Numbers '09 Tax Formular help?

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

  1. 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. macrumors 603

    swiftaw

    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. thread starter macrumors member

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

    Thanks for the swift reply.

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

    Any suggestions?

    Thanks.
     
  4. macrumors 603

    swiftaw

    Joined:
    Jan 31, 2005
    Location:
    Omaha, NE, USA
    #4
    What exactly did you type?
     
  5. thread starter macrumors member

    Joined:
    Jan 2, 2009
    #5
    0.2* in the formula function box
     
  6. macrumors 603

    swiftaw

    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. 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. macrumors 603

    swiftaw

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

    :)
     

Share This Page