Attached I have a word document with a formula, and an excel document to copy the formula into. I found that when I put the formula into the excel document it gives an error message, but I get a numerical value when I put in either of the components of the formula. I found that having ordinary formulas in a complex formula usually seems to work so long as all the ordinary formulas are on real numbers.
Also in order to get the excel file to attach I cleared the formulas from some of the cells. Fill down from B2 to B100001 before putting the formula in.
Also the formula in the word document is an array formula, so you will need to click Control-Shift-Enter when pasting the formula into a cell.
What could be causing the error message and how do I fix it?
Bookmarks