Download the New LearnVern Android App and enter Lucky Draw to win Free Certificate
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.
Have a friend to whom you would want to share this course?