How to use the IF Function in Microsoft Excel (Easy Guide)
How to Use the IF Function in Excel
One of the most popular functions in Excel is the IF function. The IF function evaluates a condition and returns one value if the condition is true and another value if the condition is false. For example, you could have Excel look at the values in a column of order totals and return Yes if a quota is met and No if a quota isn’t met.
The syntax for the IF function looks like this: =IF(logical_test, [value_if_true], [value_if_false]).
Insert an IF Function
- Click where you want to add the function.
- Click the Formula tab.
- Click the Logical button.
- Select IF.
The Function Arguments dialog box opens.
- Enter the IF function arguments:
- Logical Test: Any value or expression that can be evaluated to TRUE or FALSE.
- Value If True: The value that is returned if Logical_test is TRUE. If omitted, TRUE is returned.
- Value If False: The value that is returned if Logical_test is FALSE. If omitted, FALSE is returned.
- Click OK when you're finished.
The IF function calculates and returns a value based on the evaluation of the logical test.
Note:You can nest up to seven IF functions in a given formula.
FREE Quick Reference
Click to DownloadFree to distribute with our compliments; we hope you will consider our paid training.
- LinkedIn-ready certificate
- Skill assessments
- Bite-sized, interactive lessons
- Saved progress