• 175K Members
• 4,739 Online
• 43.8K Conversations

Highlighted
New Contributor

## IF function to work out VAT/ Sales Tax

Hi ,

UK user here.

I have a spreadsheet to track sales and income and we have recently registered for VAT so I want to add a drop down box to mark yes or no for VAT  purposes.

I've got the formula worked out to calculate VAT but how do I get Excel to work out if it should apply the formula.

In my simple brain I was thinking it would be something like;

IF(C2="yes",M2*0.2,=SUM(D2:L2), but that doesn't seem to work...........

## Re: IF function to work out VAT/ Sales Tax

Update;

Columns C-G are entries for expense amounts and it will extend over 25-30 rows.

Column I

=SUM(C40:G40)*0.2 (to work out VAT amount)

Column

=SUM(C40:G40)-I40  (to work out NET total)

I want to put an extra column in with the drop down box of yes and no to activate the VAT calculate where applicable

Related Conversations
Add 5 if a cell contains text "yes"
Titchard Family in Excel on
8 Replies
Problem with nested IF formula #Excel #2018
Laurie McDowell in Excel on
7 Replies
IF Statement with Networkdays
R S in Excel on
4 Replies
Comparing two ranges of cells in an if function
Joseph Assaf in Excel on
7 Replies
2 lists, 1 if
Bartosz Heller in Excel on
4 Replies
Help with Conditional Formatting
Carly Rose Carriere in Excel on
10 Replies