ajBigNumIsZero function
Description
Returns true if the value of number is zero or minus zero, otherwise returns false.
Syntax
ajBigNumIsZero(number)
Argument Name | Argument Type | Description |
---|---|---|
number (required) | String | 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
=ajBigNumIsZero("-0.00000000000")
The function returns TRUE since input number is zero.
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 |
---|
Number is neither a number or a string that can be converted to a number. |