Excel Functions
Click on a link to see the associated Excel functions
Boolean Functions
AND
- Category: boolean
- User level: 2
- Syntax:
=AND(condition 1, condition 2...)
- Example:
=AND(A1=B1, C3>D5)
This function returns TRUE if all of the conditions are true, and FALSE if any of them is false. The reverse function is OR.
IF
- Category: boolean
- User level: 2
- Syntax:
=IF(test, value if TRUE, value if FALSE)
- Example:
=IF(A1>10, "Yes, there will be enough", "It doesn't look like there's enough")
Functions that use true/false values are called boolean functions, or conditionals. The basic idea is "in this situation, do something, and in that situation do something else". These can be very powerful for handling different situations, especially when combined with other functions. But they can also become very complicated and hard to debug. When the equals operator (ex: =A1=A2) is used, it returns a boolean value
OR
- Category: boolean
- User level: 2
- Syntax:
=OR(condition 1, condition 2...)
- Example:
=OR(A1=B1, C3>D5)
This function returns TRUE if any of the conditions are true, and FALSE if all of them is false. The reverse function is AND.