The formula for IF is:

\

=IF(logic_test,true, false)

You can nest If statement like so:

=IF(logic_test,IF(another_logic_test_if_first_was_true,Second_true,If_second_is_false),First_logic_test_false)

I hope this helps!

Post back with your formula if this doesn't help out!

\

=IF(logic_test,true, false)

You can nest If statement like so:

=IF(logic_test,IF(another_logic_test_if_first_was_true,Second_true,If_second_is_false),First_logic_test_false)

I hope this helps!

Post back with your formula if this doesn't help out!

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.