Using the IF Worksheet Function

Excel provides a wide range of worksheet functions you can use. One of the most versatile worksheet functions is IF. This function allows you to test some condition, and then use a value if the condition is true or a different value if the condition is false. For instance, consider the following example:

=IF(A2
Notice that IF requires three arguments, each separated by commas. The first argument (in this example, A2
You are not limited, of course, to returning strings in an IF function. You can return any value you want, including the values stored in other cells. For example:
=IF(A2
In this case, if A2 is less than C2, then the value derived by subtracting B7 from B6 is returned. If A2 is not less than C2, then the value 43 is returned.