Want to highlight a helpful answer? Upvote!
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
Did someone help you, or did an answer or User Tip resolve your issue? Upvote by selecting the upvote arrow. Your feedback helps others! Learn more about when to upvote >
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
