Forum Discussion
Solved
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 Lett...
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.
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.
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.