Using MS Excel IF Then Formula: A Simple Guide

MS Excel is a powerful tool that allows users to perform various tasks, from data analysis to calculation and formatting. One of its most useful features is the IF then formula, which enables you to make decisions based on specific conditions. In this article, we will explore how to use the MS Excel IF then formula with practical examples.

Example 1: Adjusting a Value

Suppose you have a value in cell A6 and want to adjust it by 10% if its value is greater than or equal to 80. You can achieve this using the IF then formula as follows:

=IF(A6>=80,A6*1.1,A6)

In simple words, this formula says: 'If the value of cell A6 is greater than or equal to 80, then show this value multiplied by 1.1 (10% increase), else show simply this value.'

Example 2: Adding a Bonus

Let's say you have a table with a column for seniority and want to add a bonus of $100 to those who have served more than 6 months. You can use the IF then formula as follows:

=IF(Seniority>6,'$100 Bonus','')

In simple words, this formula says: 'If the value in the seniority column is greater than 6, then show a bonus of $100, else show nothing.'

Example 3: Calculating Payments

Imagine you have a table with columns for items sold and payment per item. You want to calculate the total payment based on the number of items sold. If the salesman sold more than 5 items, he will be paid $30 per item, otherwise, he will be paid only $20 per item. You can use the IF then formula as follows:

=IF(Items Sold>5,Items Sold*$30,Items Sold*$20)

In simple words, this formula says: 'If the value in the items sold column is greater than 5, then show the total payment calculated by multiplying the number of items sold by $30, else show the total payment calculated by multiplying the number of items sold by $20.'

The MS Excel IF then formula is a powerful tool that allows you to make decisions based on specific conditions. By using these formulas, you can create complex calculations and automate tasks in your spreadsheets. With practice, you will become more comfortable using this feature and be able to solve a wide range of problems.

Ms excel if then formula