Forum Discussion

Copper Contributor

Nov 03, 2021

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" ...

1. IF Function.xlsx67 KB

excel

Formulas and Functions

office 365

Daithi_O_Broin
Nov 08, 2021
@ 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.

Riny_van_Eekelen

Platinum Contributor

Nov 03, 2021

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)

Daithi_O_Broin

Copper Contributor

Nov 03, 2021

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?

Riny_van_Eekelen
Platinum Contributor
Nov 03, 2021
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.
- Daithi_O_Broin
  Copper Contributor
  Nov 03, 2021
  Thanks Riny. I will look further.
  - Daithi_O_Broin
    Copper Contributor
    Nov 08, 2021
    @ 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.