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.
|