What is IF function in Excel?

Warren S. answered • 03/14/19

Tutor

4.8 (26)

Teacher/Consultant

See tutors like this

The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result.

For example, =IF(C2=”Yes”,1,2) says IF(C2 = Yes, then return a 1, otherwise return a 2).

Still looking for help? Get the right answer, fast.

Get a free answer to a quick problem.
Most questions answered within 4 hours.

Choose an expert and meet online. No packages or subscriptions, pay only for the time you need.

1 Expert Answer