Excel FunctionsLesson 85Free preview

IF

This lesson is part of Excel · All levels

Summary

IF is an Excel basic logic function that returns the first value if the condition is correct and the second value if it is wrong. The syntax is. This function forms the basis for many other logic functions such as IFS, IFERROR, and AND.

Key points

Syntax: IF(logical_test, value_if_true, value_if_false)
The conditions can use the operator =, <>, >, <, >=, <=
The IF results can be text, numbers, or other formulas
IF is 64 levels maximum, but should be limited to easy reading

Full lesson

Code examples and quizzes

Full lessons, code examples, and quizzes are available to subscribers. 5 questions.