for graham mayor pls...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

santi - 16 Jul 2004 01:43 GMT

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!

Signature

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

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

santi wrote:

> can you help me with this formula?:
>
> if either CELL 1, CELL 2 or CELL 3 is NOT blank, OR if
> CELL 4 is not equal to 'Service Plan', enter

Reply to this Message

Greg Maxey - 16 Jul 2004 03:04 GMT

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

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, edit out the "w...spam" in gmaxey@whamspammvps.org

> Thank you for reading my message, unfortunately Peter
> Jamieson said he'd be out of town, and I still have one
[quoted text clipped - 26 lines]
>> if either CELL 1, CELL 2 or CELL 3 is NOT blank, OR if
>> CELL 4 is not equal to 'Service Plan', enter

Reply to this Message

santi - 16 Jul 2004 16:21 GMT

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

>-----Original Message-----
>I am not Graham, but the following should get you going:
[quoted text clipped - 37 lines]
>
>.

Reply to this Message

Greg - 16 Jul 2004 17:21 GMT

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

>-----Original Message-----
>it is not working, can you doble check? I think it has to
[quoted text clipped - 50 lines]
>>
>.

Reply to this Message

Rate this thread: