#1
|
|||
|
|||
Calculating Tax in Word Doc
I'm trying to auto calculate the sales tax in a form based on a drop down but am having trouble. The drop down is Taxable = Yes or No, and the tax rate would be 8%. I have searched and searched but cant figure out the right code to make this function work.
If anyone has any suggestions it would be greatly appreciated. Thanks! |
#2
|
||||
|
||||
See attached. Note that I've simplified the Price & Total columns somewhat.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
Thanks for taking a look at my issue. This works, but I need the tax to be calculated as a percentage of the subtotal. IE: 10% for example. Subtotal = 100 + 10% tax = 10. Is this doable? |
#4
|
||||
|
||||
You previously said the tax was 8%, so that's what I coded the form for - and as a percentage of the subtotal. If the tax is 10%, simply change the rate in the calculation.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
Thanks Paul,
Greatly Appreciated!!!! |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
issue in calculating field in word fillabel form | expert4knowledge | Word | 2 | 12-07-2014 05:23 PM |
calculating duration | ketanco | Project | 5 | 12-15-2011 07:15 PM |
Calculating dates | Daria11 | Word VBA | 1 | 06-08-2011 06:54 PM |
Calculating age at date | jamierbooth | Excel | 2 | 02-22-2011 03:35 AM |
Calculating Form Fields in Microsoft Word | wubba80 | Word | 1 | 06-25-2010 12:42 AM |