When using IF statements in Microsoft Excel we are required to make a decision on whether criteria is either true or false

Yes, that's correct. In Microsoft Excel, IF statements are used to make decisions based on whether certain criteria are met. The IF function is a logical function that returns one value if a condition is true and another value if it's false.

Here's a step-by-step guide on how to use IF statements in Excel:

1. Start by typing =IF( into the cell where you want the result to be displayed.

2. Next, input your logical test. This is the condition that you want Excel to evaluate as either TRUE or FALSE. For example, if you want to test if the value in cell A1 is greater than 50, your logical test would be A1>50.

3. After the logical test, type a comma , to separate the arguments.

4. Then, input the value that you want Excel to return if the logical test is TRUE. This could be a number, text, or another Excel function.

5. Type another comma , to separate the arguments.

6. Finally, input the value that you want Excel to return if the logical test is FALSE.

7. Close the function with a closing parenthesis ) and press Enter.

So, your final formula would look something like this: =IF(A1>50, "Yes", "No"). This formula tells Excel to return "Yes" if the value in cell A1 is greater than 50, and "No" if it isn't.