AND
Checks whether all conditions in a test are -true.
Syntax
expression.AND(args);
expression
- A variable that represents a ApiWorksheetFunction class.
Parameters
Name | Required/Optional | Data type | Default | Description |
---|---|---|---|---|
args | Required | number | string | ApiRange | boolean | ApiName | A condition to check. |
Returns
boolean
Example
This example shows how to check whether all conditions in a test are true.
- Code
- Result
// How to apply logical AND operation for a list of conditions.
// Use logical AND to evaluate an expression.
const worksheet = Api.GetActiveSheet();
let func = Api.GetWorksheetFunction();
let ans = func.AND(12 < 100, 34 < 100, 50 < 100); //AND logical function
worksheet.GetRange("C1").SetValue(ans);