Excel 2016

SYNTAX: IF(Something is True, then do this, otherwise do this)

Example: =IF(A1<B1,"OK",0)

EXPLANATION: If the value in A1 is less than the value in B1, the value "OK" is returned, otherwise return a 0.

Excel 2013

SYNTAX : IF(Something is True, then do this, otherwise do this)

Example: =IF(A1<B1,"OK",0)

EXPLANATION : If the value in A1 is less than the value in B1, the value "OK" is returned, otherwise return a 0.

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×