Forum Discussion
Solved
Excel functions returning unexpected result
Device and OS platform PC/Windows 10 Pro Excel product name and version number Microsoft 365 (Apps for enterprise) Excel File "1 IF Function.xlxs" , Sheet "IF Ex3" ...
@ thought I should post this as I found the issue myself.
Examining the workbook - which I had received from a colleague - I discovered that under the Formulas Tab in the Name Manager that the word no had aligned with the Value #REF! Deleting this seemed to clear the issue.
Thanks Riny. I will look further.
@ thought I should post this as I found the issue myself.
Examining the workbook - which I had received from a colleague - I discovered that under the Formulas Tab in the Name Manager that the word no had aligned with the Value #REF! Deleting this seemed to clear the issue.