IF
IF Function
This function tests a condition.
If the condition is met it is considered to be TRUE.
If the condition is not met it is considered as FALSE.
More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR.
Syntax
=IF (logical_test, [value_if_true], [value_if_false])
=IF(Condition,ActionIfTrue,ActionIfFalse)
The ActionIfTrue and ActionIfFalse can be numbers, text or calculations.
EXCEL IF FUNCTION HOMEWORK FILE