Add 20% VAT
Write the price including 20% VAT next to each net price in column B.
Changes data. A backup copy and an undo point are turned on.
What it does, step by step
- Write “With VAT” in C1
- Price with VAT in C2:C1000
- Show C2:C1000 as currency
Use it in MacroRoni: open the Starter gallery, search for "Add 20% VAT", check the steps, and adjust the sheet and ranges to fit your workbook. Preview the result before you run it.
More calculations macros
CalculationsAdd a totals rowAdd a bold total under column B and show it as currency.Changes data · backup onCalculationsRunning totalAdd a running total of column B in column C.Changes data · backup onCalculationsCount and total one categoryCount the rows where column A says Sales and add up their amounts from column B.Changes data · backup on