ajBigNumDivide function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the value of dividend divided by divisor. If the divided result has more than 20 decimal places, only 20 decimal places will be returned.
Syntax
ajBigNumDivide(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: Big Number
2) Return Type: Single Value
Example
Example 1
The division result has less than 20 decimal places.
=ajBigNumDivide(3.3,3)
The function returns the big number string "1.1".
Example 2
The division result has more than 20 decimal places.
=ajBigNumDivide("3.1234567890123456789012345",1)
The function returns the big number string "3.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 |
---|
Divisor is 0. |
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. |