=IF(condition is met, do this, otherwise do that)
Allows you to make comparisons between an actual value and what you expect it to be
IF statement can have two results:
If your comparison is true
If your comparison is false
Can be combined with a number of the functions previously discussed
The most complicated of the functions so far
Uses 3 arguments
-The first is condition you are looking at
-Second is the value if the condition is true
-Third is the value if the condition is false
Condition can be anything:
-Equals 100
-Greater than 400
-Less than a different cell
After we’ve practiced the basics, we’ll add the “nestled” IF statements into the previous formulas
If number of units is greater than 100, do not need to restock (No), otherwise restock (Yes)
=IF(D11>100,”No”,”Yes”)
Real example:
1 – Units is greater than 100
2 – Do not restock (No)
3 – Restock (Yes)