IF
Description
If the condition is True, returns the
then
value; if False,
returns the
else
value. You can nest up to 7 IF functions in a
formula.
Syntax
IF(
condition
, [
then
], [
else
])
- condition: The condition to evaluate.
- then: The value to return if the condition is True.
- else: The value to return if the condition is False.
Example
Formula | Result |
|---|---|
=IF(A1=0, A1, -A1) where A1 contains 10 | -10 |