Excel IF Function Step by Step Tutorial

Adding the "Value if False" Argument to the IF Function

The Completed IF Function

© Ted French

Adding the "Value if False" argument to the IF Function

The last section to add to the IF function is the “value if false" argument of the function followed by the right or closing round bracket.

In this case, if the value in cell A3 is not greater than the value in cell B3, we want the function to place a "B is larger" in cell D1.

For our example

type "B is larger" followed by a right or closing round bracket ")".

In cell D1 you should see the completed IF function:

=IF(A3 > B3,"A is larger","B is larger")

• The IF Function - Step by Step
• Enter the Data for the IF Function
• Starting the IF Function
• Parts of the IF Function
• Writing the IF Function Logic Test
• Adding the "Value if True" Argument to the IF Function
• Adding the "Value if False" Argument to the IF Function
• Copying the IF Function to Other Cells