Find the VAT in a price that includes it

Premium

The prices in column B include 25% VAT. In C2, work out how much of the printer's price is VAT: the price minus the price before VAT, B2-B2/(1+$F$1).

C2
ABCDEFG
1Item Price incl. VAT VAT VAT rate 0.25
2Printer 1000
3Monitor 2250
4Keyboard 375
5
6
7
8

Premium lesson

Unlock Percentages and every other lesson

This is a premium lesson. Premium lets you solve it and every other lesson, take the timed mock tests, and earn certificates you can share on LinkedIn.

Next with premium:IFAND and OR

Your first month for $9.50 $19

50% off your first month when you join today.

Get your first month for $9.50

Then $19/month. Cancel any time, and get a full refund within 14 days if it isn't for you.

Already premium? Sign in
Need help?