I am attempting to put together a spreadsheet that acts as a quote for products and services we offer. The table has 5 columns (Item #, Item Description, Qty, Unit Price, Price (USD). Services are exempt from tax, but products aren't. For example, if we build a computer for them, it would be taxed. But if we are quoting for say a 10-hour block of on-site tech support, that total wouldn't be figured into the Tax section (there is a Sub Total, Tax, and Total section at the bottom I would like to auto sum). If the service is not taxed, I put an asterisk after the item description. If there is that asterisk, I'd like the tax calculation to not count the 7% tax under the Tax section.
I have attached the table section with fake info and values for now. I'm not sure if this is possible through an expression, VBR or what.