How to Use the IF Function in Microsoft Excel

How to Use the IF Function in Microsoft Excel – By How-To Geek How-To Geek
The IF function returns different values depending on whether a condition is true or false. Use it in the form =IF(Condition,True,False). For example, =IF(C2>=60,”Pass”,”Fail”) will return “Pass” if the value in C2 is equal to or over 60 and “Fail” if the value is under 60.
Whether you’re grading exams or simply trying to make sense of a spreadsheet full of data, Microsoft Excel’s IF function can help. You can also use an IF function inside of another IF function to run deeper tests, too. We’ll show you how.