# How do I create spreadsheet in excel to calculate the cost of 17.5% VAT. 10 POINTS?

OK I need to create a total charge that calculates 17.5% vat rate for invoicing? I have no clue, please can some one give me a step by step example, 10 points as promised

Relevance

Row 1 Titles

Row 2 Data

Option 1 (Calculate VAT Separately)

Typical titles

Col A - Price Less VAT

Col B VAT @ 17.5%

Col C Price Inc VAT

A2 = Price less VAT (100)

in Col B Row 2 insert

=A2*0.175

In col C Row 2 insert

=A2+B2

Option 2 just calculate Price Inc VAT

If you want to do in all in 1 Cell

Column A=Price less VAT

Col B = Price inc VAT

In col B2 insert

=A2+(A2*0.175)

Hope this helps

• Login to reply the answers
• Yes, simply type in the formula as follows (saying for example you want 10% added on to 200) in cell A1. =200/100*110 The answer will be 220. To put in other cells simply copy and paste and then in the formula bar only change the value of the number you want increased (eg change 200 to 300, etc). Leave the remainder of the formula as it is.

• Login to reply the answers
• Formula = Number x7/47 Where number represents the cell where you input the original price.

• Login to reply the answers