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
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
> 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 "ok to
> proceed", otherwise don't enter anything.