[Peter Jamieson]

Understood, but can you try the approaches that I suggested that return
either text results or numeric results?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Tricia wrote:
Q3 is only going to be a 1, 2, or 3. Each number refers to a location
(there's only 3)
V$2... these are the specific instructions for each location where the
patient is having their procedure performed.

"Peter Jamieson" wrote:

As a temporary approach, can you pin the =IF down so that for example
you use either

a.

=IF(Q3=1,"TRUE",IF(Q3=2,"TRUE",IF(Q3=3,"FALSE")))

(or whatever the appropriate results are)

or perhaps return numeric values, along the lines of

b.

=IF(Q3=1,1,IF(Q3=2,1,IF(Q3=3,0)))

then in Word you would need a nested field along the lines of

{ IF { MERGEFIELD myfield } = 0 "FALSE" "TRUE" }

Other than that...

1.

=IF(Q3=1,V$2,IF(Q3=2,U$2,IF(Q3=3,W$2)))

What is the result if Q3 is not 1,2, or 3?

2. What is in V$2, U$2, W$2?

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Tricia wrote:
That is exactly what is happening. I created a mail merge for a co-worker
who has to send out confirmation information to several people after she gets
them scheduled for a procedure with all of their information. One of the
paragraph changes depending on the hospital they are having the procedure
performed at. So what I did is create a =IF(Q3=1,V$2,IF(Q3=2,U$2,
IF(Q3=3,W$2))) each of the columns have text in them. Any clue as to how to
get the text to show instead of "False"?

"Peter Jamieson" wrote:

Do you mean that you have a column in your Excel sheet that is populated
using an =IF formula?

If so, my best guess is that the OLE DB provider that Word uses to get
data from Excel has decided that the data type of the column containing
your =IF formulas is "text", in which case I think all the results may
be provided to Word as "false". (see http://tips.pjmsn.me.uk/t0003.htm
for more info. about this). I am not sure how to check that, but maybe
you could have a look around.

If not, can you spell out what you are doing.

Peter Jamieson

http://tips.pjmsn.me.uk
Visit Londinium at http://www.ralphwatson.tv

Tricia wrote:
I have an excel database I'm pulling my information from into a Word 2007
document. One of the fields I am pulling from is a "IF" field. Every time I
merge my document it will not pull the correct information. It always pulls
"FALSE" instead of the value that is in the field.