IF Then Merge Field

[sstreub]

I have a Merge Field "Disposition". The results can be "Prime" or "Outlet".

If the result is "Prime" I do not want to the Merge Field "Special Price" results to display anything.

If the result is "Outlet" I want the Merge Field "Special Price" results to be displayed.


I have not been successful with the attempts I have made.

I am using Word and Excel 365 and Windows 10 from my laptop.


Thank you


Steven

[macropod]

Use an IF test coded like:
{IF{MERGEFIELD Disposition}= "Outlet" {MERGEFIELD Special_Price}}
or:
{IF«Disposition»= "Outlet" «Special_Price»}

Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac or, if you’re using a laptop, you might need to use Ctrl-Fn-F9); you can't simply type them or copy & paste them from this message. Nor is it practical to add them via any of the standard Word dialogues. Likewise, the chevrons (i.e. '« »') are part of the actual mergefields - which you can insert from the 'Insert Merge Field' dropdown (i.e. you can't type or copy & paste them from this message, either). The spaces represented in the field constructions are all required.

[sstreub]

Thank you Paul.

I will test but first it is time for a cigar.

Once again you have pulled me from the fire.


Steven

[sstreub]

I had to use trial and error as how to write and where I needed to place the code to obtain the results I needed.


Executes perfectly!


Thank you Paul


Steven