I'm going to show you how to use IF statements in combination with greater and less than symbols. I setup a small scenario involving grades and how to use Excel to provide a quick view on a person failing or passing.
Here is the if statement with the greater than and less than symbols logic that I made in the video for your example.
=IF(C5""70,”Fail”,”Pass”)
Fill in the "" after C5 with the less than symbol and remove "".
...
https://www.youtube.com/watch?v=4EREYuHXASg