SOLVED

IFS

%3CLINGO-SUB%20id%3D%22lingo-sub-2776871%22%20slang%3D%22en-US%22%3EIFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2776871%22%20slang%3D%22en-US%22%3E%3CP%3EAppreciate%20if%20someone%20could%20advice%20me%20the%20reason%20I%20am%20getting%20this%20error%20for%20IFS%20function%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%220%22%20width%3D%22320%22%20cellspacing%3D%220%22%20cellpadding%3D%220%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2280%22%20height%3D%2220%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2280%22%3EC%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E1%3C%2FTD%3E%3CTD%3EStandard%3C%2FTD%3E%3CTD%3EScore%3C%2FTD%3E%3CTD%3EOutcome%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E2%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E6%3C%2FTD%3E%3CTD%3E%23NAME%3F%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20height%3D%2220%22%3E3%3C%2FTD%3E%3CTD%3E8%3C%2FTD%3E%3CTD%3E0%3C%2FTD%3E%3CTD%3E%23NAME%3F%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%3DIFS(B4%26lt%3B%3DA4%2C%22P%22%2C%22F%22%2CB4%3D%220%22%2C%22NA%22)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2776871%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2777111%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777111%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1088661%22%20target%3D%22_blank%22%3E%40choongko%3C%2FA%3E%26nbsp%3BTry%20it%20this%20way%3A%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIFS(B2%3D0%2C%22NA%22%2CB2%26lt%3B%3DA2%2C%22P%22%2CB2%26gt%3BA2%2C%22F%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2777151%22%20slang%3D%22en-US%22%3ERe%3A%20IFS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2777151%22%20slang%3D%22en-US%22%3EStrange%2C%20I%20am%20still%20getting%20the%20same%20error.%3C%2FLINGO-BODY%3E
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.