ajBigNumDivideToInteger function
Description
Returns a BigNumber whose value is the integer part of dividing the value of dividend by divisor.
Syntax
ajBigNumDivideToInteger(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
=ajBigNumDivideToInteger("3333333333333333333.333",2)
The function returns the division result without decimal place "16666666666666666666".
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. |