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.
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.
The screen was showing me the same original cell answer for the other drag copied cells. Minutes later and after posting the file here, my spreadsheet refreshed and all the calculations are correct for each cell. I checked the file uploaded and they show what I now see on my screen, not what I saw when I saved it. This behaviour feels surreal... I will take a break now to look for hidden cameras and listen for a room of people laughing hysterically at my reactions.