IF

Returns depending on the condition the true or the false argument. Or, if condition evaluates in an error, the function returns the error message and is not calculated.

Syntax

=IF(Condition, TrueValue, FalseValue)

Arguments

Name	Description
Condition	Condition to check.
TrueValue	Optional value to return, if the condition is true. If not specified nothing is returned.
FalseValue	Optional value to return, if the condition is false. If not specified nothing is returned.

Return

The appropriate value depending on the condition.

Examples

Formula	Result	Comment
=IF(3>1, "Warning", "OK")	"Warning"	As the condition results to TRUE, the first value is returned.
=IF(A1="no_streamsheets", "Warning", RETURN()) with A1 = #NA	#NA	A1 returns an error and the function will not be calculated