Download Practice Excel File Here: Conditional Formula
Conditional formulas can really up your Excel game. This can provide a lot more functionality to your workbooks.
So what are conditional formulas? Conditional formulas work based on the following logic: IF condition THEN action.
examples: IF gas tank is low THEN go to gas station
IF age > or = to 21 THEN you can drink
The basic Excel formula for this is =If()
=If(logical test,[value if true],[value if false])
In the first example, we are going to see if a value in Column A is > 10. If it is, we will return High. If not, it will return Low.
It also works with strings.
In this example, we are asking if any name in column D matches Bob, then Yes, else No.