How to add VAT to a calculated sum in a cell?

Closed
Emma - Jun 4, 2010 at 07:06 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 4, 2010 at 08:30 AM
Hello,

I am having troubles working this out on Excel. I have a cell which I have done a small calculation and I want to add VAT onto this total to get my total figure including VAT.

The sum is as follows:
£150 (cellA1) x £2109 (cell B1) = £316,350 (cell C1)

How do I add VAT (17.5%) to the total (£316,350) in the same cell C1.

It would later read like this but I do not know how to put it in a formulat:
£316,350 (cell C1) x 17.5% VAT = £55,361 + £316,350 = £371,711.

Basically the figure in cell C1 (the figure including VAT) should be £371,711. Please can someone show me how you would write this as a formula to get the total amount including VAT into one cell.

Much appreciated!

Related:

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Jun 4, 2010 at 08:30 AM
try this


=A1 * B1 * 1.175


or

= (a1 * B1) + (a1 * b1 * 0.175)
6