spot_img

IF Function in Excel

You can learn here what IF function is and how to use it.

IF function is one which are used the most often in Excel. IF is a logical function. But you can not only check TRUE / FALSE values.

Excel if function logical test true false

Let’s take a look at some IF function examples. IF Function contains from 3 parts:

  1. Logical test – IF function checks if this test is true or false in the cell
  2. Value if true – IF function puts this value if logical test is true
  3. Value if false – IF function puts this value if logical test is false

Here you have some examples:

IF exam is passed?

The simplest example is to make a table with exam results. In this table Excel will show, if the Student passed the exam.

Excel IF function exam results table

Thanks to IF function you can automatically check, if the student passed the exam. The formula is:

=IF($C3>50,”PASSED”,”FAILED”)

IF formula checks the logical test, which is if the student got more points than 50. If logical test is true, Excel writes PASSED. If student got less then 50 points Excel writes FAILED.

Excel IF function simple formula example

Isn’t it simple?

IF exam is passed? More difficult example

Let’s do something more difficult. You want to check if the student passed the exam and you want to get the mark.

Excel IF function table more difficult

A is more than 90 points. B is more than 75 points. C is more than 60 points. D is more than 50 points. It is not hard to do. You must to do more logical tests in Excel’s formula. You check if it is more than 90 points. If it is more, mark is A. If it is not, check if more than 75 points… If all logical tests aren’t true, the mark is E. Formula is:

=IF($C3>90,”A”,IF($C3>75,”B”,IF($C3>60,”C”,IF($C3>50,”D”,”E”))))

Excel IF function logical test

If formula seems to be complicated, but it is easy to get it. And the effect is magnificent.

Simple IF Formula

This sample is about acknowledging the information that would help the comprehension of a simple IF formula. In this case, we want to know the amount we make from selling a specific product.

Simple IF Formula

IF and Average

This is an example that simultaneously uses both the average and if formula.

IF and Average

IF and SUM

Usage The issue here is that we would like to know how much the company would make, at a level that addresses the total amount that the company would make, in combination with the quantity of products that we’d have in the inventory.

IF and SUM Usage

Double IF in one Formula

The formula here is about using two IF formulas together.

Double IF in one Formula

IF, AVERAGE and SUM

in one Formula This example focuses on combining 3 different formulas into 1 to find a result.

IF AVERAGE and SUM in one Formula

IF, MIN and MAX

This example use IF, MIN and MAX formulas to find the answer.

IF MIN and MAX

IF and Date

This is the usage of IF and Date formula. This sample focuses on how much we’ve made today, if we only focus on a specific price.

IF and Date

Double IF in one Formula

This example use two IF formula, because we would like to start a new project that would allow us to cleanse our remaining inventory. It was intended that in the event that we have not sold all the products after a specific period of time, we were going to sell it for a specific amount of money. Usage of double IF formula allow productivity to help determine how much we would make from selling it in a specific project.

IF and IF in one Formula

Net Worth after Expenses

We want to know the profit we would make after paying all expenses, and selling the products at a specific price. This is where we would be using double IF formulas and SUM.

Net Worth after Expenses

SUM and IF

This is the usage of both functions: sum and if – and find the answer that we are looking for.

SUM and IF

Template

You can download the Template here – Download
spot_img
Previous articleAvoid Errors Using IFERROR-Everyone Should Know
Next articleLinking Text Box To A Specific Cell