If it is, then it returns Pass, else it returns Fail. It checks whether the score is more than 35 or not. Here is the formula that will do this: =IF(B2>35,"Pass","Fail") You can easily find this out by using the IF function in Google Sheets. Suppose you have the marks of students in an exam and you want to specify whether a student has passed or failed (as shown below). Example 1: Checking a Single Condition With If Function Now let’s look at some examples to understand how to use the IF function in Google Sheets in real-life scenarios. Its a logical test, right If the value is 50, the formula would return TRUE else FALSE. If you don’t specify the value_if_false argument and the checked condition is not met, the function would return FALSE. Its meaning is whether the value in A1 is equal to 50 or not.