ajBigNumSubtract function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the value of number1minus number2.
Syntax
ajBigNumSubtract(number1, number2)
Argument Name | Argument Type | Description |
---|---|---|
number1 (required) | String | The number to subtract from. It should be in number or string format. For example, -1 or "-1". |
number2 (required) | String | The number to subtract. It should be 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
=ajBigNumSubtract(2,1)
The function returns "1" as the minus 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).
Parameter | Error Message |
---|---|
number1 | Number1 should be numeric. |
number2 | Number2 should be numeric. |