Hi,
I am trying to get my spread sheet to work out tax only if it is deductable. So one column is titled gross, one is titled net and one is titled tax. I want to be able to type in the gross cost in the gross column, if i pay tax on the item i want to put a "Y" in the tax column (Yes tax has been paid) and then the net ammount would be automatically calculated and put in the net column. If I put a "n" in it (No tax has not been paid) then the net column stays the same as the gross amount.
Can you help?
Bookmarks