MS Excel: How to use the If Function with example and practical

 HOME PAGE 

About of Logistics functions:-

                                                     It is also known as the conditional function. If functions is one of these . 

If functions:-

Examples 1. Write a formula who find the greater number and smaller number.  If two number is given.     

Solution:-

                  Let's   Fist number a is = C3

                        Second number b is = C4

    Formula   [ = if(C3>C4,"a is greater than b","b is greater than a")   ]

Look at my practical sheet:-

Result of practical sheet:-

When changes the value of a and b then result will be changed. 

Example 2. Find the value of functions =80÷8÷2.

Solution:- 

             This type of functions solved in two step

Step1.   80÷8  = 10

Step 2. 10÷3   = 5 Ans

Look at the practical sheet :-

Result of above Formula:-

Example 3. Write a formula who find the failure and pass students in your classroom.  Students data is given in the excel sheet. 

Solution:-

     Look at the practical sheet and sea the using of If Functions :-

Other Cell If function Formula:-

Example 4.