# AND

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## Content



This function calculates logical AND.

## Syntax

AND(*bool1*,*bool2*,...)
AND(*array*)
AND(*array1*,*array2*,...)
AND(*expression*)
AND(*expression1*,*expression2*,...)

## Arguments

For the arguments of this function, provide numeric (0 or 1) or logical values (TRUE or FALSE) for up to 255 arguments. You can also specify a single array instead of listing the values separately, or up to 255 arrays. You can also specify the logical argument as an expression.

## Remarks

This function returns TRUE if all its arguments are true; otherwise, returns FALSE if at least one argument is false.

## Data Types

Accepts logical data (Boolean values of TRUE or FALSE) or numerical values (0 or 1). Returns logical data (Boolean values of TRUE or FALSE).

## Examples

`AND(D12,E12)`
`AND(R12C42,R12C5,R12C1)`
`AND(D2:D12)`
`AND(R12C1:R12C9)`
`AND(true,true,true)` gives the result TRUE
`AND(TRUE(),FALSE())` gives the result FALSE
`AND(5+3=8,5+1=6)` gives the result TRUE

## Version Available

This function is available in product version 1.0 or later.

## See Also

[NOT](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionNOT) \| [OR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsMtoQ/FunctionOR) \| [Logical Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functslogic)