Results 1 to 3 of 3

Thread: Using IF field

  1. #1
    New Lounger
    Join Date
    Jan 2001
    Location
    Barbados, West Indies
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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. #2
    Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    85
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using IF field

    You need to make the calculation a field too:

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

    Ian.

  3. #3
    New Lounger
    Join Date
    Jan 2001
    Location
    Barbados, West Indies
    Posts
    17
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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
  •