Forum Discussion
IFS Function not working in Microsoft Office 365
That's since your column B is formatted as text. Return format to General and re-enter the formula (F2->Enter), it works. Please see attached.
It was on comma missed
=IFS(L2="STA","STA",L2="0JK","K",L2="K","1",L2="1","2",L2="2","3",L2="3","4",L2="4","5",L2="5","6",L2="6","7",L2="7","8",L2="8","9",L2="9","10",L2="10","11",L2="11","12",L2="12","")
Even more confused now...
I corrected the missing comma before I pasted/posted the equation and the equation was still underlined and your version has the prior equation references to cell L2 and not A1 which is what I pasted into my post.
I went back to that equation cell and copied the equation text/formula to a new cell and it is no longer underlined, but the original equation cell. Is there an original memory that a cell holds onto?
and I forgot to mention that it is displaying as text (not underlined) but still not behaving as a function.
I think I get it now... The field that I was putting the equation into was formatted as a text field before I copied it to another spreadsheet. As soon as I pasted it into a virgin cell it all worked...
May be an issue with Copy/Paste/Drag_Paste as opposed to the actual Function IFS
Documented steps and the unorthodox behavior in the attached spreadsheet with a subset of data and the formula in question for debugging and testing.
