6 Replies Latest reply: Aug 31, 2013 3:13 AM by robin lewis
robin lewis Level 1 Level 1 (0 points)

Hi, I am getting lost in trying to make a simple percentage formula plase can you help?

 

all I want  is cell B to tell me 20% percentage of the total in cell A

 

this is to automate tax and vat totals for invoices I make to will need to make variations of the percentage but this should be super simple I am just too simple to work it our :-s

 

Thanks for your help


iMac, OS X Mountain Lion (10.8.2), 27Inch 2013, 32 GB Ram
  • 1. Re: A simple percentage of one cell
    Yellowbox Level 5 Level 5 (4,570 points)

    Hi Robin,

     

    Screen Shot 2013-08-31 at 7.17.29 PM.png

     

    Formula in B2 (and Fill Down) is:

     

    =A2*B$1/100

     

    The Absolute Row $1 keeps the reference to B1 as you fill down.

     

    To use a different percentage, enter a new value in B1.

     

    Regards,

    Ian.

     

    Message was edited by: Yellowbox. The Absolute Row $1 keeps the reference to B1 as you fill down.

  • 2. Re: A simple percentage of one cell
    robin lewis Level 1 Level 1 (0 points)

    Hi Ian,

     

    thanks for the reply, this whole thing baffles me. How ever I still have failed to make it work please see what I have done in the attached photo.

     

    Screen Shot 2013-08-31 at 10.27.34.png

  • 3. Re: A simple percentage of one cell
    robin lewis Level 1 Level 1 (0 points)

    Ah figured it out I just put 30/100 rather than the cell.

     

    thank you so much

  • 4. Re: A simple percentage of one cell
    Yellowbox Level 5 Level 5 (4,570 points)

    Hi Robin,

     

    Sorry, I did not know you had text in Cell G1. The formula needs a number. Assuming you want 30% of A2, you could use:

     

    =A2*30/100

     

    or

     

    =A2*30%

     

    Regards,

    Ian.

  • 5. Re: A simple percentage of one cell
    Barry Level 7 Level 7 (29,180 points)

    HI Robin,

     

    If I'm readng your headers correctly, column C shows the price including VAT. In column G, you are calculating 30% of that amount, and your header indicates that this is a tax (separate from the VAT). If this calculation is correct, then you are paying a 30% tax on the base price of the item AND a 30% tax on the VAT on that item.

     

    Is that correct, or should the 30% tax apply to the price of the item prior to VAT being added?

     

    Regards,

    Barry

  • 6. Re: A simple percentage of one cell
    robin lewis Level 1 Level 1 (0 points)

    Thanks Barry,

     

    The 30% tax cells are basically telling me how much I have put aside for tax out of the Total of every invoice. this way I make sure that I get a nice bonus at the end of the tax year. the acutal tax figure is on a diffrent collum.

     

    thanks for noticing though that could have been a mistake worth fixing :-)