If you work in Excel, you probably already know that Excel has countless functions and formulas that can facilitate your work in the program. One of Excel’s most popular formulas is the IF function. Once you master the IF function, it will undoubtedly become one of your most used functions in Excel.
IF function – what can it?
The IF function allows you to calculate logical comparisons between a result in the spreadsheet and what you expect. It may sound a bit complicated, but it’s actually quite simple.
“If we are going to cut the IF function to the bone, it is simply about indicating whether the result reflects what is expected.”
Let’s take an example.
We now assume that you work in a telemarketing company. In the company, you have Associated a number of different sales representatives, all of whom must meet a sales target. Let’s assume that you have 250 sellers who all have to sell for 10,000 kr. a week.
Therefore, you naturally have a database of the different sellers and their sales figures. If we cut it to the bone, it could f.ex. look like this:
Instead you have to skim all 250 columns to see if the number is above or below the 10,000 kr./ week, you can now use the IF function to do the calculation for you.
IF function displays in its simplest form:
If (something is true, then the result is “X”, otherwise the result is”Y”).
In the example of the telemarketing company you will thus be able to define your comparison to the 10,000 kr./ the week that is the target of the 250 sellers. With the IF function, you can now calculate a comparison that can be explained in the following way:
If the goal of the 10,000 is reached, then the result is true (”yes”), if not then the result is false (”no”).
How to use the IF function
When you need to use the IF function in practice, we recommend that you write out the comparison that you would like to examine. That way it is far easier to write the actual formula in Excel.
If we stick to the example from before, below you can see a sample of the spreadsheet with the 250 different sellers who have all Associated a variety of data and information about their sales efforts.
If you want to quickly get an overview of whether the individual sellers have met their sales goals, you can use the following calculation:
If the seller has achieved the sales target ”it must say “Target met”, if not, it must say”not met”. As a formula it will look like this:
=If (C2 & gt; D2” ‘met”” ‘not met’)
Then simply drag the formula down over the entire column E, and you will automatically get a quick overview of which sellers have achieved the goal and which have not.
The IF function makes it easy and quick to set up scenarios and compare data. If you want to get to know even more of Excel’s smart features, you can join an Excel course
Excel has a huge catalog of formulas and functions that can ease your workflow and make your work in Excel much easier. The IF function is undoubtedly one of the most popular functions in Excel, but it is far from the only one that you can benefit from in your work.
How to use Excel’s popular if feature
If you work in Excel, you probably already know that Excel has countless functions and formulas that can facilitate your work in the program. One of Excel’s most popular formulas is…
Written d. 6 apr 2017 – No comments