ajBigNumDivide function

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.