## A simple percentage of one cell

231 Views 6 Replies Latest reply: Aug 31, 2013 3:13 AM by robin lewis
Level 1 (0 points)
Currently Being Moderated
Aug 31, 2013 1:51 AM

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
• Level 4 (3,640 points)
Currently Being Moderated
Aug 31, 2013 2:27 AM (in response to robin lewis)

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.

• Level 4 (3,640 points)
Currently Being Moderated
Aug 31, 2013 2:45 AM (in response to robin lewis)

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.

• Level 7 (28,815 points)
Currently Being Moderated
Aug 31, 2013 2:58 AM (in response to robin lewis)

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

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.