Forum Discussion
IFS Function not working in Microsoft Office 365
I am using the following function on a Windows machine with the latest version of Office 365 (as per the help page) but the cell with the formula just shows the equation underlined. Cell A1 has Letters and Numbers (formatted as text).
| mailto:=@IFS(L2=%22STA%22,%22STA%22,L2=%220JK%22,%22K%22,L2=%22K%22,%221%22,L2=%221%22,%222%22,L2=%222%22,%223%22,L2=%223%22,%224%22,L2=%224%22,%225%22,L2=%225%22,%226%22,L2=%226%22,%227%22L2=%227%22,%228%22,L2=%228%22,%229%22,L2=%229%22,%2210%22,L2=%2210%22,%2211%22,L2=%2211%22,%2212%22,L2=%2212%22,%22%22) |
I am perplexed... Any suggestions?
https://support.office.com/en-us/article/ifs-function-36329a26-37b2-467c-972b-4a39bd951d45?NS=EXCEL&Version=90&SysLcid=1033&UiLcid=1033&AppVer=ZXL900&HelpId=xlmain11.chm60655&ui=en-US&rs=en-US&ad=US
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.
6 Replies
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...
