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.