Hello,

I have a table in Word 2010 where I need to add tax to give me a total dollar amount. I have a check box called 'Tax Exempt?' in cell B12, and a formula in D12 which shows the tax in dollar amounts, =Product(D11,.0835), number format of $#,##0.00.

I want to be able to link the check box in B12 with the $ amount in D12 so that if I check the box saying this customer is tax exempt then D12 will read $0.00. Can I either:

(1) put a formula in D12 that says if check1 is true then put $0.00 in D12 and if not, then calculate the tax? If so, what would like formula look like? What I tried didn't work, 'Syntax Error'.
OR
(2) create a macro for D12 that does the same thing? If so, can you tell me the macro? I'm not very knowledgable about macros.

BTW, D12 was just created by inserting a formula via the Table Layout tab and selecting Formula. It wasn't created by inserting a text box using the Developer tab, so it doesn't have the ability to select Properties and then choose Run Macro upon Entry or Exit.



I would appreciate any help! Thank you.