Skip to Content

IF

Specifies a logical test to perform

Syntax

IF(logical_test, [value_if_true], [value_if_false])

Parameters

  • logical_test: Required. A value or expression that can be evaluated to TRUE or FALSE
  • value_if_true: Optional. The value to return if logical_test is TRUE. If omitted, returns TRUE
  • value_if_false: Optional. The value to return if logical_test is FALSE. If omitted, returns FALSE

Example

=IF(A1>10, "High", "Low")
Returns: VariesSince: Excel 2003