Hi Excel Guru's. Hope you are all well?!
The help I received on here last week was amazing so here i am back for some more...
I have created a new invoice sheet : looking to complete it with auto VAT calc.
Table is headed as:
Description | Staff | Rate | Hours | VAT Rate
Firstly I have dropdown lists for different staff rates - using VLOOKUP this works perfect!
VAT Column: is a dropdown list using validation
F14 - 18 = lists contain 20% / 5% / 0% VAT
So dependent on the charge you pick. It’s here that I am trying to get the subtotal, VAT and Total Cost to work in order of the VAT .
The invoice could contain 2 items 20% and 1 item 5% if that makes scene.
F21 = Subtotal
F22 = VAT
F23 = Total Cost
Any guidance would be greatly appreciated.
Thank you in advance.
Bookmarks