6 Replies Latest reply: Aug 31, 2013 3:13 AM by robin lewis
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

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

Hi Robin,

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

• ###### 3. Re: A simple percentage of one cell
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
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
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
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 :-)