ajBigNumMin function

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.