Forum Discussion
Solved
IFS
Appreciate if someone could advice me the reason I am getting this error for IFS function? A B C 1 Standard Score Outcome 2 8 6 #NAME? 3 8 0 #NAME? =IFS(B4<=A4,"P"...
- Solved .. Thanks a lot.
Strange, I am still getting the same error.
choongko Then your Excel version probably doesn't support the IFS function. From the help screens, this is what it says:
"Note: This feature is available on Windows or Mac if you have Office 2019, or if you have a Microsoft 365 subscription"
So, if IFS doesn't work in your Excel version you are stuck with regular nested IF functions.
EDIT: Should have seen this from the start as the #NAME? error indicates that Excel doesn't recognise something as a valid function. But I just copied your original formula into a mock-up schedule and got a different error. Then I focussed on resolving that error in stead of addressing the name error.
