It uses the syntax: =IF(test, value_if_true, value_if_false) For more complex scenarios, Excel also offers the IFS function, ...