-
logical_expression1
- [
]
- logical_expression2
- ...
- logical_expression1—Expression that evaluates to either true or false.
- —[optional]
- logical_expression2
- ...
Additional expressions that evaluate to true or false.
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 |