Using IF field

[barke_p]

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,

[IanSaunders]

You need to make the calculation a field too:

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

Ian.

[barke_p]

Thanks, that did the trick.