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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |