It uses the syntax: =IF( test , value_if_true, value_if_false) For more complex scenarios, Excel also offers the IFS function ...
Thankfully, Microsoft Excel's COUNTIF formula swoops in to save the day ... the gist is that COUNTIFS allows you to use ...