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.
Daithi_O_Broin You forgot the quote marks around no increase.
This is what you have in H4 right now:
=IF(H3>H2,"Increased",no Increase)
- Hi Riny. I know that there should be quote marks. The issue is that when using the Functions Library popup for the IF function, the Function Arguments Popup automatically puts quote marks on anything put into the Value_if_ boxes unless what is written in is No . This is what I am trying to sort out. Why does the Popup/Functions arguments not automatically put the quote marks in?
Daithi_O_Broin Actually, I never use that function dialogue box. But I tried it now and the quote marks are included automatically in my case, for both the if_true and if_false values.
Don't know why it doesn't work for you.
- Thanks Riny. I will look further.