ajBigNumNegate function
Description
Returns a BigNumber whose value is the value of number negated, i.e. multiplied by -1.
Syntax
ajBigNumNegate(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
=ajBigNumNegate("1000000000000000000000")
The function returns "-1000000000000000000000" as the negated result.
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. |