Forum Discussion

Consulting999's avatar
Consulting999
Copper Contributor
May 22, 2022
Solved

How do I create a nested IFS function for numbers and blank cells?

I am collecting data for an exam we conduct at work. We need to count how many people have passed, failed, and how many did not even take the exam (so 3 categories total). I have been playing around with IF and IFS functions but I believe I need to create a nested IFS function in order to represent all 3 options:

 

1st category --> if the cell containing the result exceeds 50% --> PASS

2nd category --> if the cell containing the result is less than 60% --> FAIL

3rd category --> if the cell containing the result is empty --> DNS

 

P.S. it is a 10 question multiple-choice exam so the only options for results are 10%, 20%, 30%, etc. just in case someone thinks we are omitting some result options 🙂

How do I do this? Thanks!

  • Consulting999 

    Let's say R2 contains a result.

    =IF(R2="","DNS",IF(R2>50%,"PASS","FAIL"))

    or

    =IFS(R2="","DNS",R2>50%,"PASS",R2<=50%,"FAIL")

    This can be filled down.

2 Replies

Resources