Course Content

Course Content

If Condition in MS Excel

How To Use If Condition

 

Now we will see that how we can use if condition in MS Excel.

If condition in MS Excel is quite similar to if condition which we use for our programming languages.

Now to use if condition in our Excel sheet we can write it as a formula, such as '=if(G3>15,H3+2000,H3' where G3 is Years in Company and H3 is Salary.

From this example we want to show that, whosever years are greater than 15 in this company will receive 2000 Rs. bonus in their salary.

So now when we will implement our if statement we will observe that whosesoever years are more than 15 in this company will receive bonus while others will receive their usual salaries.

Now we can also add another if statement inside an if statement. For example '=if(G3>15,H3+2000,if(G3>10,H3+1000,H3))' where G3 is Years in Company and H3 is Salary.

From this example we want to show that who's ever years are greater than 15 in this company will receive 2000 rupees bonus in their salary, and also those who are above 10 years will received thousand rupees as bonus.

So this is how if condition works in MS Excel.

FAQs

An "if" condition is a conditional statement that is used to compare two values. If the condition is true, then one set of instructions are executed. If the condition is false, then another set of instructions are executed.

Excel is a powerful spreadsheet tool that offers conditional formatting, which allows you to apply different formats to cells depending on the content of the cell. For example, if a cell contains a number, it will be formatted with a green background color. If it contains text, it will be formatted with a red background color.

An if condition can be used to check whether a variable is true or false. In Excel, the if condition can be written in two ways: either as an =IF() function or as an =AND() function.

There are four types of If Conditions:

  • If-then statement
  • If-then-else statement
  • Nested if statements
  • Switch statements

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere