Forum Discussion

choongko's avatar
choongko
Brass Contributor
Sep 22, 2021
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"...
Formulas and Functions
  • choongko's avatar
    choongko
    Sep 23, 2021
    Solved .. Thanks a lot.
JSHEP73's avatar
JSHEP73
Brass Contributor
Sep 23, 2021
Try in C2 and copy down:

=IF(B2=0,"NA",IF(B2<=A2,"P","F"))
choongko's avatar
choongko
Brass Contributor
Sep 23, 2021
Solved .. Thanks a lot.

Resources