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 ...
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    May 22, 2022

    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.

HansVogelaar's avatar
HansVogelaar
MVP
May 22, 2022

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.

Resources