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
Check whether all conditions in a test are true in a spreadsheet.
// How to apply logical AND operation for a list of conditions in a spreadsheet.
// Use logical AND to evaluate an expression in a spreadsheet.
const worksheet = Api.GetActiveSheet();
let func = Api.WorksheetFunction;
let ans = func.AND(12 < 100, 34 < 100, 50 < 100); //AND logical function
worksheet.GetRange("C1").SetValue(ans);