IF Formula of MS Excel

IF Formula of MS Excel

The IF formula in Microsoft Excel allows you to make logical comparisons between a value and what you expect, and then return a result based on the outcome of that test. The general syntax of an IF formula is:

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

• logical_test is the condition that you want to test.
• value_if_true is the value that you want returned if the logical test evaluates to true.
• value_if_false is the value that you want returned if the logical test evaluates to false.

For example, =IF(A1>10, "Greater than 10", "Less than or equal to 10") returns "Greater than 10" if the value in cell A1 is greater than 10, and "Less than or equal to 10" otherwise.