Important Logical Function: Simple IF in Ms Excel Functions

Hello Friends,

We all use  Ms Excel for different purposes.We have variety of Excel Functions available.Excel Functions are divided into various categories:

1. Mathematical
2. Textual
3. Financial
4. Logical
5. Date/Time

And Many More...

I have Some Knowledge about Logical Excel Functions.I wanted to share it with you all:

1. IF Function:This function is used to check condition and returns value depend upon the condition.Syntax of if is: if(condition,value_if_true,value_if_false) where:

condition is the Logical Test which we would like to test;

value_if_true is outcome which appears on cell if condition or Logical Test is true;

value_if_false is outcome which appears on cell if condition or Logical Test is false;

either value_if_true or value_if_false returns by function depends upon Logical Test Fails or Pass

Example 1:

Suppose we want to check the Salary Column in Employee Sheet whether salary is greater than 20000 or not?

Important Tip: we should type the text value in double quotes while using it in function.for eg.  yes or no given in double quotes inside function.

Example 2:

Calculate Tax  5%  in the Tax Column in Same Employee Sheet whose salary is greater than 20000 and 0 for others using if Function?

In this way you can use simple if function.In the next session,we will learn more about if function.

we will learn how to use if function with multiple conditions that what we call it nested ifs.

Also,we will use if function with Logical AND and Logical OR function. That's Interesting thing about IF Function that we can use it in multiple ways.