I cannot figure out how to remove calculated sales tax in a column if that sale is exempt on a basic daily sales trx spreadsheet.
Column H is =F1*.0875 (F1 being the subtotal and .0875 is our sales tax rate). I have inserted column G before it where the sales clerks can enter a capital E if that customer is exempt. I want H to return the formula results if G is blank, or return 0.00 if G has the letter E in it.
Thank you!