AND

Modified on Tue, 30 Apr at 1:37 PM

Introduction

Returns true when all given inputs are true and false otherwise.


FORMULAAND(boolean1, boolean2, [boolean3, ...])
EXAMPLE FORMULA

AND(temp_col > 80, temp_col < 90)

EXAMPLE INPUT100
EXAMPLE  OUTPUTFalse


Sample Usage


Valid ExamplesInvalid 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

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article