The IF function ... Excel. You can use text for the test as well as the results. Be sure to include the text within quotation marks. For this example, we have student grades. We want to display ...

We want to use the IF statement to determine who passes and who fails. We will click the cell where we want the result. In this example, we will click the cell under the pass and fail column.