Skip to content
**Our thanks, your savings. Limited Time Period Offer (Up to 85% OFF)**
# EXCEL FUNCTION – IF

Microsoft Excel “IF Function” is categorized as Logical Function and provides output as per the logical conditions provided. Function returns the value if logical function is “True” or “False”. IF function is quite often used function in Microsoft excel and helps to determine the decisions.

In an “IF function” there will be two output i.e. TRUE or FALSE since either the statement will be “TRUE” or “FALSE”. If the statement is matching or correct, then output will be “TRUE” or if the statement is not matching or not correct then the output will be “FALSE”

**Advantage of IF Function:**

IF function is very advantageous for the users who uses logical conditions to determine the action plans for the problem statement. if you are working on the large database then it makes very difficult to get the logical output one by one, and only “IF function” helps to apply the conditions to complete database at once and save time and efforts with maximum accuracy

**Where “IF Function” can be used:**

**Things to Remember:**

## Recommended Articles

## Similar Posts

### EXCEL FUNCTION – MOD

### How to calculate compound interest in Excel: daily, monthly, yearly compounding

### EXCEL FUNCTION – INDEX

### EXCEL FUNCTION – SUMPRODUCT

### EXCEL FUNCTION – SUMIF

### Excel Function – SUBTOTAL

– Selection of any item (i.e. if price of any item is less than $100 then decision should be “BUY” else “DO NOT BUY”)

– Acceptance of proposals (i.e. if any project cost is greater than $1000 then output should be “DO NOT ACCEPT” else “ACCEPT”)

– Head or Tail (if Head comes then show “I WON” else “I LOSE”)

– Likewise, whenever there is two option and need to make choices then IF function can be used

**Syntax:**

=IF(logical_test,[value_if_true],[value_if_false]

]**Syntax Description:**

**logical_test,** argument is used to provide the logical conditions, like if A is equals to (A=), if A is greater than (A>) or less then (A<) etc.

**[value_if_true], **argument is output argument and provides result in-case statement or logical condition is TRUE

**[value_if_false], **argument is also output argument and provides result in-case statement or logical condition is NOT TRUE

We need to ensure that the logical conditions that we are providing are as per our requirement and are correct. Incorrect providing of logical conditions will leads to incorrect output and wrong decisions.

For example, if we need to purchase items which are less than (<) $100 however conditions are provides as greater than (>) $100 then it will lead to incorrect results and decision making.

**Example 1: Selection of items (Buying Decisions)**

We have a list of products and need to make the buying decision. We want to make decision that, if price of the product is less than $100 then output should be “BUY” or if price of product is greater than $100 then output should be “DO NOT BUY”. We will be following below syntax:

Syntax: =IF(B2<100,"BUY","DO NOT BUY")

**Example 2: Acceptance of proposals**

Suppose there is a list of projects cost available with you and you need to make choices that, if project cost is greater than $1000 then “DO NOT ACCEPT” else “ACCEPT” the project. Syntax of the said condition will be:

Syntax: =IF(B2>1000,"DO NOT ACCEPT","ACCEPT")

**Example 3: Head or Tail**

Imagine you played game and you would win only if “Head” comes. You have the database available that how many times Head or Tail did come. In this case you can simply get to know how many times you won by following below IF conditions:

Syntax: =IF(B2="HEAD","I WON", "I LOSE")

Hope you liked. Happy Learning.

Don’t forget to leave your valuable comments!

MOD function is used to get the remainder of number that is divided by divisor. MOD Function has two required arguments i.e. number and divisor.

How to use the compound interest formula in Excel and gives examples of how to calculate the future value of an investment with yearly, monthly, or daily interest. It also shows you step-by-step how to make your own Excel compound interest calculator.

INDEX function is used to get the value from a cell range or table, function returns the value from a table where row and column intersect with each other.

SUMPRODUCT function performs multiplication of numbers within arrays and then sum the values SUMPRODUCT function has array1, 2.. arguments.

SUMIF function is used to get the “total sum” for number of times the criteria across range is met. SUMIF Function has two required arguments.

Excel Function SUBTOTAL Excel Function “Subtotal” is most commonly used formula in excel and it can make your work easy while performing simple mathematical calculations because of variety of features like: – You can use…