![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Detect a cell has un-approved change or not? | LongTTH | Excel Programming | 1 | 05-20-2012 02:22 AM |
![]() |
ubns | Excel | 5 | 05-14-2012 04:21 PM |
Link and change source for multiple tabs from excel to powerpoint | excel3 | PowerPoint | 1 | 01-19-2012 02:01 AM |
CHange colour of footer if a cell changes to red | OTPM | Excel | 0 | 05-26-2011 07:15 AM |
highlight cell after checkbox | flatk | Word | 0 | 01-25-2007 12:32 PM |