# AND Function

Used within another function to return true if all provided logical expressions are true.
Sample Usage
IF(AND(Status1 = "Complete", Status2 = "Complete", Status3 = "Complete"), "All Tasks Complete", "Tasks Incomplete")
Syntax
AND(
• logical_expression1
• [
• logical_expression2
• ...
]
)
• logical_expression1
Expression that evaluates to either true or false.
• logical_expression2
• ...
—[optional]
Additional expressions that evaluate to true or false.
Examples

This example references the following sheet information:

Row #

In Stock?

Units Sold

Order Date

Price Per Unit

1

true

78

02/12/19

\$15.00

2

false

42

02/15/19

\$35.50

3

true

217

02/20/19

\$200.00

Given the table above, here are some examples of using an AND() function in a sheet:

Formula

Description

Result

=IF(AND([Units Sold]3> 50, [In Stock?]3 = 1), "In Stock", "Requires Restock")

IF the “Units Sold” column row 3 is greater than 50 and the “In Stock” column equals 1 (true), return the value “In StocK”, if not return the value “Requires Restock”.

In Stock

=IF(AND(NOT(ISBLANK([Order Date]1)), [In Stock?]1 = 1), "Ready To Ship", "Out of Stock")

IF the “Order Date” column row 1 is not blank and the “In Stock” column row 1 equals 1, return the value “Ready To Ship”, if not return the value “Out of Stock”.