I'll keep it basic, but I have Bigger Plans.
I want a line in a letter to say "You have tax to pay" or "You are due a refund". As we mail merge there are several numbers that are inserted into the letter (and many more on the actual Excel spreadsheet that just don't get pulled in) that would show which statement was true. Let's say the Excel file has a column called "Tax due/repayable this year" and the Word document "(«Tax_due/repayable_this_year»)" as a field.
I have found Insert Field and the IF statement, which appears to be what I need. But I can't find the correct words to use, specifically what I should put in this instance for Expression 1 Operation Expression 2 No matter what I put it never works).
I went for IF «Tax_due/repayable_this_year»>0 "Payment" "Repayment" but that displays ">0"
I tried IF Tax_due/repayable_this_year>0 "Payment" "Repayment" but that just says "Payment" regardless of the amount shown.