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
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.
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.
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.
Ah figured it out I just put 30/100 rather than the cell.
thank you so much
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.
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
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 :-)
A simple percentage of one cell
