Conditional Formulas in MS Excel

Create conditional formulas

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF function to create conditional formulas.

The IF function uses the following arguments.

Formula with the IF function

 logical_test: The condition that you want to check.

 value_if_true: The value to return if the condition is true.

 value_if_false: The value to return if the condition is false.

Source: http://office.microsoft.com/en-us/excel-help/create-conditional-formulas-HP005251012.aspx