IF function

description:

This function returns the second argument if the condition is met, otherwise returns the third argument.

 

syntax:

=IF( logical_test[value_if_true][value_if_false] )

 

required arguments:

logical_test Condition.

 

optional arguments:

[value_if_true] This value is returned when the condition is met.
[value_if_false] This value is returned when the condition is not met.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.