ajBigNumIsLessEqual function
Description
Returns true if the value of number1is less than or equal to the value of number2, otherwise returns false.
Syntax
ajBigNumIsLessEqual(number1, number2)
| Argument Name | Argument Type | Description |
|---|---|---|
| number1 (required) | String | The number to be checked against with number2. It should be a number in number or string format. For example, -1 or "-1". |
| number2 (required) | String | The number to be checked against with number1. It should be a number in number or string format. For example, -1 or "-1". |
The function will return:
1) Return Value: Boolean
2) Return Type: Single Value
Example
=ajBigNumIsLessEqual("1234567890123456789","1234567890123456789")
The function returns TRUE since number1is equals to number2.
Error Scenarios
It will return #VALUE! when missing any required parameter or mismatch parameter type. Besides, system will raise error for below scenario(s).
| Error Scenario |
|---|
| Number1 is neither a number or a string that can be converted to a number. |
| Number2 is neither a number or a string that can be converted to a number. |