Good morning,
I am seeking help with nested if statements in mail merge & am going around in circles trying to figure out.
I need to create a paragraph with the following conditions -
IF (Mergefield Cover Type) is E1
and (Mergefield Overseas) is not blank "
Sentence for this cover"
Then the rest of the paragraph needs to return different values depending on one to three conditions at a time (I am attempting to nest it all together) -
IF (Mergefield Waits Apply) = Y "
Sentence for waits apply"
or
IF (Mergefield Waits Apply) = Y
and (Mergefield Previous Extras) = N "
Sentence for previous extras"
or
IF (Mergefield Waits Apply) = Y
and (Mergefield Previous Extras) = Y
and (Mergefield Upgrade Extras) = Y "
Sentence for upgrading waits"
They need to return a blank if they are not true
Any assistance from your logical minds would be greatly appreciated

Renee