IF+Function

If you are confused about the IF function, then this may help you.

The IF function looks like this: **IF**(**logical_test**,**value_if_true**,value_if_false)

This means that you must have three parts:
 * 1) Create a logical test
 * 2) Return a value if the test is true
 * 3) Return a value if the test is false

The logical test is an equation or test of some sort that checks to see whether the test is true or false. The function will never return both values. The test is either true or false, there is no median. If the test passes, the true value is returned, if it fails, the false value is returned.

An example of a logical test would be: (assume that the value in A1 is 7) =IF(A1>5,"Good","Bad") The function runs the test, 7>5, which is true. This would return the value Good. (If A1 is 3) =IF(A1>5,"Good","Bad") The function runs the test, 3>5, which is false. This would return the value Bad As long as the logical test makes sense it will return the value that you define. Hopefully this helps.