Using the IF Function in Excel In this example, we are going to use a table containing the test marks of students. We want to use the IF statement to determine who passes and who fails.

Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

If you don’t see the Automate tab in Excel for the web, and you’re part of a large organization, talk to your Microsoft 365 administrator. If you’re on your own and you don’t see it, you ...