It uses the syntax: =IF(test, value_if_true, value_if_false) For more complex scenarios, Excel also offers the IFS function, ...
Microsoft Excel is incredibly versatile, but there are a lot of functions you might not even know about. These are some of ...