Excel has a versatile If, Then function built right into it. We’ll show you how to use the IF function in Excel with a number of helpful examples.

The IF function contains three arguments: Logical_test, Value_if_true, and Value_if_false. You type in the formula as IF (Logical_test, Value_if_true, Value_if_false), or you can use the Insert ...

IF function. The IF function allows you to apply a condition to your data whereby one result is returned if your condition is TRUE and another result if the condition is FALSE.IF functions can be ...

If you need to use the Excel IF function and multiple conditions, consider using the IFS function instead. This allows you to test multiple conditions in order, picking the first that returns true.

2. SUM functions. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum.