This isn’t desperately important but I am sure there must be a way to do this and if I knew how I think I could use the idea for other things I do. It would be useful knowledge for me to have…
At the moment I have columns with the unit cost, no of units, total exc vat amount, then a ‘vat’ column containing 1 or 1.2 (1 is for zero rated, 1.2 is for liable for 20% VAT)
Then an inc Vat column which is just the total ex vat column multiplied by the Vat column. Which gives the right numbers - it works…
However it is easy to read the VAT column as the no of units column. (So 1 unit not 5 etc)
I was just going to hide the Vat column -but then it also needs to be obvious whether I thought the item was liable for VAT or not. I could do some background colour or add an additional column containing Zero or 20% for info, not included in any calculations.
But I am sure there is a way to do something like =G3 * (if E3 = ‘20%’ 1.2 , if E3 = “Zero” 1)
Is there?
Temp eg VAT sheet.ods