ajBigNumSqrt function
Description
Returns a positive square root of the value of a big number.
Syntax
ajBigNumSqrt(number)
Argument Name | Argument Type | Description |
---|---|---|
number (required) | String | The big number which you want the square root. It should be a positive number 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
=ajBigNumSqrt(2)
The function returns "1.4142135623730950488", 20 decimal places will be kept.
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 |
---|
Number is neither a number or a string that can be converted to a number. |
Number is negative. |