Calculate tax based on if there's an asterisk in another column

Hello,

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.

Thanks!

GENIUS!!! LOL! I never thought of adding a space!

But now the issue is, it is adding the entire price of the non-taxable stuff to the taxes. So, instead of $797.99, it is showing $2,797.98. It needs to just not be in the calculation at all if it has that asterisk/space, like an "IF" statement or something.

I figured it out! I added a "*0" to the part about the asterisks. Woohoo! Thank you so much

Please Login or Register  to view this content.