9 MS Excel- If Formula

The IF formula in Excel is used to perform logical tests and return different values based on whether the test is TRUE or FALSE. The basic syntax is:
=IF(logical_test, value_if_true, value_if_false)