Understood, but can you try the approaches that I suggested that return
either text results or numeric results?
Actually misunderstood, sorry. I stil can't get Excel to misbehave in
the way you describe, but if you are doing something different in the
first 8 records of the sheet, that is most likely the cause (and if that
is the case, I'd be interested to know what that something is).
Otherwise macropod's "do it in Word" solution is the one you need.
Peter Jamieson
http://tips.pjmsn.me.uk
Visit Londinium at
http://www.ralphwatson.tv
Peter Jamieson wrote:
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.