IF function in Excel

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

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.

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.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.