for graham mayor pls...

[santi]

Thank you for reading my message, unfortunately Peter
Jamieson said he'd be out of town, and I still have one
issue to solve asap (I posted the below msg yesterday
under original thread), hope you can help me with that
one:

If (either CELL 1, CELL 2 or CELL 3 is NOT blank) OR (if
CELL 4 is NOT EQUAL to 'Service Plan') enter "ok to
proceed", otherwise don't enter anything.

Thank you very much in advance, this has taken me about 4
days of research already!

***

I thought Peter Jamieson was helping you with this?
Please keep your
associated messages in thread! As Peter said in his last
reply, we need more
information about the data file and the potential
combinations of content eg
could cell 4 AND any of cells 1 to 3 have content?

Please answer in the original thread!

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[Greg Maxey]

I am not Graham, but the following should get you going:

{IF "{MERGEFIELD Cell_1}{MERGEFIELD Cell_2}{MERGEFIELD Cell_3}" = ""{ IF "
{MERGEFIELD Cell_4}" = "Service Plan""""Ok to proceed"}"Ok to proceed"}


All { } bracket pairs are entered with CTRL+F9.

HTH

 

[santi]

it is not working, can you doble check? I think it has to
do with the "" signs...

 

[Greg]

santi,

Works here. I triple checked. In the sample below "ok to
proceed printed on test records 2,4-10. 1 and 3 were
blank. I believe that is the logic you requested. The
spacing is critical. The results of:

"{MERGEFIELD Cell_1}{MERGEFIELD Cell_2}{MERGEFIELD
Cell_3}" must be empty (i.e., no space or nothing) if your
data source cells 1,2 and 3 are in fact blank (again no
spaces.

There was one pair of extraneous speech marks that you
could delete, but it makes no difference:

Here is the field again:

{IF "{MERGEFIELD Cell_1}{MERGEFIELD Cell_2}{MERGEFIELD
Cell_3}" = ""{ IF {MERGEFIELD Cell_4} = "Service
Plan""""Ok to

proceed"}"Ok to proceed"}

Cell 1 Cell 2 Cell 3 Cell 4 Test
Service Plan 1
2
Service Plan 3
4
5
1 Service Plan 6
2 7
3 Service Plan 8
9
10