# How to use Excel IF Function

How to use Excel IF Function2016-04-28T13:41:14+00:00

## Quick Intro

Use Excel IF Function to test a condition, if that condition is TRUE then it will return a value which you have specified and if that condition is FALSE it will return another value.

In simple words, you can test a condition and function will a return result with you have specified with TRUE and FALSE respectively for both of the results.

## Syntax

IF(logical_test,value_if_true,value_if_false)

• logical_test A condition which you want to evaluate.
• value_if_true  Value which you want to get if that condition is TRUE.
• value_if_false Value which you want to get if that condition is FALSE.

## More Information on Excel IF Function

• You can use IF Function for nested formulas.
• The maximum number of nested condition you can perform is 64.
• You can use comparison operators to evaluate a condition in IF function.

## Examples

In the below example, we have used a comparison operator to evaluate different conditions.

1. I have used a specific text to get in the result if condition met or not.
2. You can also use TRUE and FALSE to get in result.
3. If skip to specify a value to get the result if the condition is TRUE, it will return zero.
4. And, if you skip specifying a value to get the result if the condition is FALSE, it will return zero.

In the below above example, we have used IF function to create a nesting formula. we have specified a condition and if that condition is false then we have used another if function to evaluate another condition and perform a task and if that condition is FALSE we have used another IF.

This way we have used IF for five times to create a nesting formula. You can use the same for 64 times for a nesting formula.

## What’s Next?

To learn more about Excel AVERAGE Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

There are also you have OR | AND functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.