SOLVED

IFS

Contributor

Appreciate if someone could advice me the reason I am getting this error for IFS function?  

 

 ABC
1StandardScoreOutcome
286#NAME?
380#NAME?

=IFS(B4<=A4,"P","F",B4="0","NA")

5 Replies

@choongko Try it this way:

 

=IFS(B2=0,"NA",B2<=A2,"P",B2>A2,"F")

 

in C2 and copy it down.

 

This is what the Help screen says about the use of the IFS function:

"The IFS function checks whether one or more conditions are met, and returns a value that corresponds to the first TRUE condition."

 

 

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.

 

Try in C2 and copy down:

=IF(B2=0,"NA",IF(B2<=A2,"P","F"))
best response confirmed by choongko (Contributor)
Solution
Solved .. Thanks a lot.