IF and Nested IF Functions

It checks a condition and always returns TRUE or FALSE.

It checks a condition and returns one value if TRUE, another if FALSE.

It always returns a numeric value based on a condition.

It evaluates multiple conditions and returns an array of values.