This function is used when we want to return some meaningful result in place of an error. Step 4: Copy the IF function across all the required cells, and we are returned the correct result as shown in the following screenshot. This has been accomplished by passing the arguments as shown in the following screenshot. If marks are greater than 40, then the result should be PASS otherwise, FAIL. Step 3: The second and third arguments are ‘value_if_true’ and ‘value_if_false’, respectively. We passed the condition as the argument in the IF function as shown below. In this case, the condition is that if marks are more than 40, then the result is PASS, or else it is FAIL. Step 2: The first argument is the logical test. Step 1: When we enter the IF function, Excel automatically pops up the list of arguments, as shown in the following screenshot.
Now, if the passing marks are 40, then we would like to declare the result for each student in terms of PASS and FAIL. There’s a simple dataset containing data of students and their marks. We will demonstrate the use of the IF function using a very simple example. It is a very simple logical function that checks if the condition to be validated as true or false. You can download this Logical Functions Excel Template here – Logical Functions Excel Template 1.
