Lastly, to this result you need to add the initial price of the product or service = (Initial Price *VAT) + Initial Price. So, the formula to calculate VAT using Excel would be =(A1*B1)+A1, giving you the total price including VAT. Following this example, type in =(50*0.21)+50. The final result will be 60.5.