ajBigNumAbs function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the absolute value, i.e. the magnitude, of the value of number.
Syntax
ajBigNumAbs(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: BigNumber String
2) Return Type: Single Value
Example
=ajBigNumAbs("-1234567890123456789")
The function returns the absolute value "1234567890123456789".
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. |