Mail Merge
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. |
All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com