1. ## Using IF field

Word 2000

Hi,

I am customising an invoice template which uses fields to calculate a total cost. However, because VAT (aka Sales Tax) is not applicable to total sales expressed in USD I need a way to check to see if a particular table cell contains the string "USD\$", display "0.00" if so, otherwise display the VAT amount by multiplying the net total by 15 percent. At the moment I have:

{IF Currency = "USD\$" "0.00" C15*15%}

..where "Currency" is a bookmark in a cell [I presume it has to be??], C15 is the invoice's net total and 15% is the VAT rate. The problem seems to be with the syntax of the false element of the IF statement (probably the 15% - I am thinking in Excel), but what should it be? All advice gratefully received.

Thanks,

2. ## Re: Using IF field

You need to make the calculation a field too:

{IF Currency = "USD\$" "0.00" {= C15*15%}}

Ian.

3. ## Re: Using IF field

Thanks, that did the trick.

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•