I have created the following spreadsheet
Which should calculate two sets of prices
In the end column, I have the total cost of how much the items will cost and it is labelled sub amount, it is called sub amount because I want it to calculate the total sub amount minus the discounted price but in total amount, column shows the price without the discount.
Then in the vat coloum, I want to add vat rate to the Total amount
I also need the tax column to be removed but the calculations to still take place as per normal. Without setting the Cell to T for taxable
Capture.JPG
Bookmarks