I have the below formula embedded in cell C285 and the output in cell C285 is perfect however when I drag this formula down, I get the #NUM error message in cell C286.
When I do a manual calculation using "Calculate now" via the Tab: Formula; the output is being calculated on cell C286...