ajBigNumIsLessEqual function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
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. |