How to use Excel IF Function

how to use excel if function

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.

Use Excel Operators In Excel IF Function

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.

Use Excel IF Function To Create Nested Functions

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.

Related Tips

Sample File

download sample file to learn more about this tips

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.