Trying and Failing to use nested IF Statement in MS Word

Hi,

Are you missing any delimeter in the syntax? I have updated it with "," please check if it works.

IF "<<Quote_to_Contract_Commitment_Level>>" = "Quarterly" "Vierteljährlich",
  {IF "<<Quote_to_Contract_Commitment_Level>>" = "Monthly" "Monatlich",
    {IF "<<Quote_to_Contract_Commitment_Level>>" = "Other" "Andere" "Jährlich" }
}

That didn't work unfortunately, now it treats the comma as the fallback word. It would have surprised me, of the many examples I've looked at, none utilize comma delimiters in Word. Only spaces.

Before and after merge posted below.

Hi @chrishigh 

You may try in this format instead of nested

{IF "<<Quote_to_Contract_Commitment_Level>>" = "Quarterly" "Vierteljährlich"  ""}

{IF "<<Quote_to_Contract_Commitment_Level>>" = "Monthly" "Monatlich"  ""}

{IF "<<Quote_to_Contract_Commitment_Level>>" = "Other" "Andere" "Jährlich" } 

Regards

S.Aj

@chrishigh When nesting it usually is in the false condition and should like this format. A third nest would replace the last tag location.

{IF "<<tag>>" = "Retainer" "True" "{IF "<<tag>>" = "Sample" "" "<<tag>>"}"}

@chrishigh  That's odd that usually works for me, are you inserting the new conditional text inside rather than copy pasting?

Not sure what you mean, what I've pasted above is exactly as it appears in the Formula builder of Word (except for the very first and vary last brackets which self-populate when the formula is saved and field visibility is toggled, I included them for illustrative purpose).

@Safiya your method is cheating LOL. 😆 But, it does work as long as I use FOUR unique statements instead of three. By including the false statement in your last formula, you cause Jährlich to appear under every circumstance, including combined with the other two values when summoned. Here's the working set:

There is one unseen benefit to using this method - Word is rather restrictive about the length of formulas you can build, and this does get around that.

@chrishigh I usually do my formulas using ctrl+f9 to insert the new conditional text rather than the formula builder, that's what I meant by inserting.