How To Add If Statement In Excel

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the spider web Excel 2021 Excel 2021 for Mac Excel 2019 Excel 2019 for Mac Excel 2016 Excel 2016 for Mac Excel 2013 Excel 2010 Excel 2007 Excel for Mac 2011 Excel Starter 2010 More...Less

The IF office is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you lot look.

So an IF statement tin have two results. The first result is if your comparing is True, the second if your comparison is False.

For instance, =IF(C2="Yep",1,ii) says IF(C2 = Yes, and so return a one, otherwise return a 2).

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Use the IF function, i of the logical functions, to return one value if a condition is true and some other value if it's false.

IF(logical_test, value_if_true, [value_if_false])

For example:

=IF(A2>B2,"Over Budget","OK")
=IF(A2=B2,B4-A4,"")

Argument name	Clarification
logical_test (required)	The condition you lot desire to examination.
value_if_true (required)	The value that y'all want returned if the outcome of *logical_test* is TRUE.
value_if_false (optional)	The value that you want returned if the result of *logical_test* is Fake.

Simple IF examples

Cell D2 contains a formula =IF(C2="Yes",1,2)

=IF(C2="Yes",1,ii)

In the in a higher place instance, cell D2 says: IF(C2 = Yes, and then return a 1, otherwise return a ii)

Cell D2 contains the formula =IF(C2=1,"YES","NO")

=IF(C2=i,"Aye","No")

In this example, the formula in prison cell D2 says: IF(C2 = 1, then render Yep, otherwise render No)As you run across, the IF function can be used to evaluate both text and values. It tin too be used to evaluate errors. Y'all are not express to only checking if 1 affair is equal to another and returning a unmarried result, you can also use mathematical operators and perform additional calculations depending on your criteria. You can also nest multiple IF functions together in order to perform multiple comparisons.

=IF(C2>B2,"Over Upkeep","Within Upkeep")

In the above example, the IF function in D2 is saying IF(C2 Is Greater Than B2, then render "Over Budget", otherwise return "Within Budget")

Formula in cell E2 is =IF(C2>B2,C2-B2,"")

=IF(C2>B2,C2-B2,0)

In the above illustration, instead of returning a text consequence, nosotros are going to return a mathematical calculation. And then the formula in E2 is saying IF(Bodily is Greater than Approaching, and so Subtract the Budgeted amount from the Bodily amount, otherwise render nothing).

=IF(E7="Aye",F5*0.0825,0)

In this example, the formula in F7 is saying IF(E7 = "Aye", then calculate the Total Corporeality in F5 * eight.25%, otherwise no Sales Revenue enhancement is due so render 0)

Note:If y'all are going to use text in formulas, y'all need to wrap the text in quotes (e.g. "Text"). The just exception to that is using Truthful or Simulated, which Excel automatically understands.

Common bug

Problem	What went wrong
0 (zilch) in cell	There was no argument for either value_if_true or value_if_False arguments. To see the right value returned, add argument text to the 2 arguments, or add TRUE or False to the argument.
#Proper name? in cell	This usually means that the formula is misspelled.

Need more than assistance?

You can always ask an expert in the Excel Tech Community or get support in the Answers community.

Come across Also

Calculation operators and precedence in Excel

Utilize nested functions in a formula

Using IF to bank check if a cell is blank

Video: Advanced IF functions

IFS function (Microsoft 365, Excel 2016 and later)

Advanced IF functions - Working with nested formulas and avoiding pitfalls

Training videos: Advanced IF functions

The COUNTIF function will count values based on a single criteria

The COUNTIFS role will count values based on multiple criteria

The SUMIF function will sum values based on a single criteria

The SUMIFS function will sum values based on multiple criteria

AND office

OR role

VLOOKUP function

Overview of formulas in Excel

How to avoid broken formulas

Observe errors in formulas

Logical functions

Excel functions (alphabetical)

Excel functions (by category)

Demand more aid?