Forum Discussion
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!
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
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.
- Consulting999Copper Contributor
HansVogelaar thanks so much that worked perfectly!