Microsoft Office - Excel Formula - IF

The IF function in Microsoft Excel is a powerful tool used to make logical comparisons between a value and what you expect. The formula returns one value for a TRUE result and another for a FALSE result.

Syntax:

=IF(logical_test, value_if_true, value_if_false)

logical_test: The condition you want to evaluate. (e.g., A1 > 10)

value_if_true: The value to return if the condition is TRUE.

value_if_false: The value to return if the condition is FALSE.

---

Examples:

1. Basic Usage: If the value in cell A1 is greater than 10, return "Yes"; otherwise, return "No":

=IF(A1 > 10, "Yes", "No"

2. With Numbers: If the value in cell B1 is equal to 100, return 1; otherwise, return 0:

=IF(B1 = 100, 1, 0)

3. Nested IF: To evaluate multiple conditions, you can nest IF functions. For example: If A1 is greater than 90, return "Excellent"; if greater than 50, return "Good"; otherwise, return "Poor":

=IF(A1 > 90, "Excellent", IF(A1 > 50, "Good", "Poor"))

4. Using with Text: Check if cell C1 contains "Pass"; if yes, return "Congratulations"; otherwise, returnCongratulations

=IF(C1 = "Pass", "Congratulations", "Try Again")

5. Combining with Other Functions: Combine IF with functions like AND or OR for more complex conditions:

If both A1 > 10 and B1 < 20, return "Valid"; otherwise, return "Invalid":

=IF(AND(A1 > 10, B1 < 20), "Valid", "Invalid")

If A1 = "Yes" or B1 = "Yes", return "Proceed"; otherwise, return "Stop":

=IF(OR(A1 = "Yes", B1 = "Yes"), "Proceed", "Stop")

---

Notes:

Enclose text values in quotation marks ("").

Logical comparisons include operators like =, >, <, >=, <=, <>.

Ensure your values and cell references match the expected data type (e.g., numbers vs. text).

About Seedha Saral

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.