View Single Post
 
Old 10-07-2014, 07:52 AM
Mulith Mulith is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 15
Mulith is on a distinguished road
Default Tables withmergefields, if statement and calculations.

Hi,

I am currently working with a table in Word which forms part of invoice.

The invoice makes use of a table within word and pulls data into Word using merge fields. At this point in time it uses merge fields to pull in the description of a fee and the date of the transaction in column a and the gross amount of the fee in column C.

What I'd like to do is split off the VAT element into column B.

As VAT is not always 20% I need to search the value within the description merge field in column A for the VAT amount to be applied:

Example of fee description:
05 Jun 2014 - 60% Take On Fee (£84.00 + VAT @ 20%)


What I'd like to do is add an if statement in column B which checks the description for "+ VAT @ 20%" if it finds this value then to take the value from column C and get the VAT component as the value in column B.

Else if the "+VAT @ 5%" then split off 5% VAT into column B

Else add 0.00 as value within column B.

If this could be achieved it would be an absolute life saver. Any help would be greatly appreciated.
Reply With Quote