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
- Code
- Result
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);