Excel's logical functions test whether a statement or data is true or false, before enabling the program to carry out an ...
IF( test , value_if_true, value_if_false) For more complex scenarios, Excel also offers the IFS function, which allows ...