ajBigNumMin function
Available for AlchemyJ Excel Library, AlchemyJ Enterprise Edition
Description
Returns a BigNumber whose value is the minimum of the arguments.
Syntax
ajBigNumMin(numbers)
Argument Name | Argument Type | Description |
---|---|---|
numbers (required) | Range / Array | An array of number in number or string format. It could be a cell range or an array string. For example, D1:F1 or {12, "13", 14} |
The function will return:
1) Return Value: BigNumber String
2) Return Type: Single Value
Example
Example 1
Provide the number list in array format.
=ajBigNumMin({12, "13", 14})
The function returns 12 since it is the minimum number of the inputted array.
Example 2
Provide the number list in a range.
=ajBigNumMin(A9:C10)
The function returns 11 since it is the minimum number in the specified range.
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 |
---|
Not all elements in numbers can be converted to a number. |
Unrecognized array format. |