I'm trying to merge a document with a data source from
Excel but the result I get is always the first
percentage field repeated for all statements
regardless of the condition. It ignores the rest of
the nested if_statement.

{ IF {MERGEFIELD PledgeCode} = “05 Foundation” “5%” “{
IF {MERGEFIELD PledgeCode} = “05 Builders” “7%”{ IF
{MERGEFIELD PledgeCode} = “05 Encouragers” “10%”{ IF
{MERGEFIELD PledgeCode} = “05 Restorers””15%”{ IF
{MERGEFIELD PledgeCode} = “05 Sustainers” “20%” “” }”
}” }” }”

This outputs 5% regardless of the PledgeCode

Vera