I have a spreadsheet that is used for data collection and that has several
calculated fields. Many of these fields are mail merged in to a report
document in Word. Some of the calculated fields check for errors in the
calculations (divide by zero for example) which can occur when data is not
collected that would be needed for the calculation. In that case I have it
evaluate to a message that should merge into the report and make sense.

Example:
=IFERROR((4.95/AE62-4.5)*100,"Unable to be determined by skinfold")

Problem is that the cell in excel does the correct thing but the merged data
that gets to the report is still the error and not what should be merged
IFERROR is true.

It seems that the merge ignores the text even though it shows in the cell as
it should.

And no, I dont want manually enter this by hand for each calculation that
has an error. That does work but the point here is automation.

Any ideas?

Thanks for any help.