User Profile
Daithi_O_Broin
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Excel functions returning unexpected result
@ 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.1.8KViews0likes0CommentsRe: Excel functions returning unexpected result
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?1.9KViews0likes3CommentsExcel 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" attached Using the Functions Library in Cells H4 and again in K4 Method Clicking on cell H4 Drop down "Logical" and choose "IF" Logical_test H3>H2 Value_if_true Increased Value_if_false No Increase Expected outcome/Formula Result No Increase Actual result #REF! Visual noted - When using the Function Library>>IF>>Function Arguments popup the formula automatically put Quotation marks around true and false values EXCEPT where the worn NO forms part of the argument. i.e. formula returned when IF popup closed as =IF(H3>H2,"Increased",No Increase) instead of expected =IF(H3>H2,"Increased","No Increase") When the quotation marks are manually inserted then the result returns as expected. As the Functions Library facility is being used, requiring manual input of quotation marks is not something expected. It is only when the Value_if_true or Value_if_false is No that this happens. Not returns as expected as does any other word - see K5 and K6.Solved2KViews0likes5Comments
Recent Blog Articles
No content to show