Calculating Tax in Word Doc

DORFER · #1 12-21-2016, 10:17 AM

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!

macropod · #2 12-21-2016, 05:32 PM

See attached. Note that I've simplified the Price & Total columns somewhat.

DORFER · #3 12-21-2016, 06:32 PM

Quote:

Originally Posted by macropod

See attached. Note that I've simplified the Price & Total columns somewhat.

Thanks @macropod!

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?

macropod · #4 12-21-2016, 07:05 PM

Quote:

Originally Posted by DORFER

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?

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.

DORFER · #5 12-21-2016, 08:21 PM

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