Blog

Deep Dive to If Formulas in Excel (Part-1)

Deep Dive to If Formulas in Excel (Part-1)

                               


                                       Today we discussing the most widely used function in the excel by all level of the excel users and we trying to make deep dive to Five Scenarios where If Formula is very useful to our routine job.

 

Definition of IF Instruction:

According to Microsoft Excel, IF statement is defined as a function which “checks whether a condition is met, returns one value if True and another value if False”.

 

In plain simple English IF function is an instruction that checks any condition, if the condition is found to be TRUE then it returns a predefined value however if the condition is False, it returns a different predefined value

 

Syntax of Excel IF Statement:

The syntax of If Function in Excel is as follows: 

=IF (Logic_Test, Value_if_True, Value_if_False) 

Here, ‘Logic_Test’ refers to the expression that is to be evaluated. 

‘Value_if_True’ is the output of IF Statement if the ‘Logic_Test’ is TRUE. 

‘Value_if_False’ is the output of IF Statement if the ‘Logic_Test’ is FALSE.

 


 

Example -1

Here HR Assitant need to prepare the report based on the Bonus and management had given instruction find out the number of employees eligible for the bonus and not eligible for bonus, if He had the list of 1000 employees it is difficult for him to prepare, So he started to write the if formula for solving this issue and make the logical test like this.

=If(Salary is more than 5000,”Eligible to Bonus”,”Not Eligible for Bonus”)




 

Example -2

Here another task is given to HR Executive for calculating the bonus based on the salary and criteria provided by the management is “If Salary is less the 5000, rate of bonus is 10% and if is more the bonus will 15% of the salary.

So here the if formula will be “If(Salary is less than 5000,Salary*10%,Salary*15%)

As per the below example, the formula is

=IF(D14<5000,D14*10%,D14*15%)

 




CLICK HERE TO DOWNLOAD THE WORK BOOK

 

 

Click here IF Formula in Multiple Conditions

 

Video Link: Watch Video

Phone : +91 8606648045
Email : info@excelskillcorner.com
Excel Skill Corner
Kerala, India.