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”.

Ready To Ship

=SUMIF([Order Date]:[Order Date], AND(MONTH(@cell) < 4, MONTH(@cell) >= 1), [Price Per Unit]:[Price Per Unit])

Sum the “Price Per Unit” column IF the “Order Date” column has a Month value less than 4 (April) and a Month value greater than or equal to 1 (January). Rows 1, 2, & 3 apply because their Month is 2 (February). 

$250.50