ajBigNumMod function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the value of dividend modulo divisor, i.e. the integer remainder of dividing dividend by divisor.
Syntax
ajBigNumMod(dividend, divisor)
Argument Name | Argument Type | Description |
---|---|---|
dividend (required) | String | The dividend in number or string format. For example, -1 or "-1". |
divisor (required) | String | The divisor 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
=ajBigNumMod("1000000000000000000000",3)
The function returns 1 as the remainder of dividing "1000000000000000000000" by 3.
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 |
---|
dividend is neither a number or a string that can be converted to a number. |
divisor is neither a number or a string that can be converted to a number. |