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
Formula with the IF function
Callout 1 logical_test: The condition that you want to check.
Callout 2 value_if_true: The value to return if the condition is true.
Callout 3 value_if_false: The value to return if the condition is false.
more @ http://www.merawindows.com/Forums/tabid/324/forumid/90/threadid/35797/scope/posts/Default.aspx