Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    IF Statement (Office 2000)

    Hello,
    I don't use Word very much, so I'm way out of my league on this one. I know nothing about fields, tables etc in Word. I don't know how this document was created in order to fix it. I tried looking at the help files but that confused me even more. Excel is so much easier.

    I have attached a stripped down version of a contract document that merges information from an Access query. I just discovered an "error". If we have customers that are tax exempt, they obviously shouldn't be charged tax. The word document charges tax on everyone.

    I would like to change the "field" for "Applicable Tax" to an "IF" statement that basically says "If 'BillCode3' equals 'Tax Exempt', enter 0.00, otherwise multiply the 'Sub-total' by 6%.

    I tried revising, like I would in Excel, but it just doesn't work.

    Any help here would be greatly appreaciated.

    Thanks!
    Attached Files Attached Files
    Louise

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: IF Statement (Office 2000)

    You can do the following:
    - Right-click the text field (in the cell to the left of the text "Applicable Text")
    - Select Toggle Field Codes from the popup menu.
    - You'll see { =g5*6% # "#,##0.00" }
    - Select g5*6%
    - Press Ctrl+F9 to insert field brackets { } (don't type the brackets yourself).
    - It should now lool like { ={ g5*6% } # "#,##0.00" }
    - Position the insertion point to the left of g5.
    - Type IF followed by a space
    - Press Ctrl+F9 to insert another pair of field brackets.
    - You should now have { ={ IF { }g5*6% } # "#,##0.00" }
    - Between the field brackets, type MERGEFIELD BillCode3
    - You should now have { ={ IF { MERGEFIELD BillCode3 }g5*6% } # "#,##0.00" }
    - Position the insertion point to the right of the inner }, to the left of g5.
    - Type ="Tax Exempt" followed by a space, a 0 (zero), and another space.
    - You should now have { ={ IF { MERGEFIELD BillCode3 }="Tax Exempt" 0 g5*6% } # "#,##0.00" }
    - Press F9 to hide the field codes and update the field.

    Phew!

  3. #3
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Statement (Office 2000)

    Hi Hans!

    Thank you so much! Wow! I never would have figured this one out!
    Thanks for such detailed instructions! I'll give it a try when I get back to work on Monday.

    You're a life saver!
    Louise

  4. #4
    3 Star Lounger
    Join Date
    Jul 2001
    Location
    Florida, USA
    Posts
    394
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: IF Statement (Office 2000)

    Hi Hans,

    It works great! Thank you very much!
    Louise

Posting Permissions

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