Introduction
Returns true when all given inputs are true and false otherwise.
| FORMULA | AND(boolean1, boolean2, [boolean3, ...]) |
| EXAMPLE FORMULA | AND(temp_col > 80, temp_col < 90) |
| EXAMPLE INPUT | 100 |
| EXAMPLE OUTPUT | False |
Sample Usage
| Valid Examples | Invalid Examples |
| AND(Text Column="Kiwi", TRUE) | AND(Text Column="Kiwi", Text Column="Apple") Shows all values as false. |
| AND(Number Column > 12, Number Column <43) | AND(Date="2014-03-12 00:00:00.000", TRUE) |
| AND(Number as Text Data Type >"10", Number as Text Data Type <"600") |
Notes
- Dates cannot be applied to AND formula,
- AND formulas must need specification of whether a value is TRUE/FALSE
- When using the “text” data type, be sure to use quotes.
See Also
OR
IF
NOT
Still having issues? Contact us at support@gigasheet.com
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article