ajBigNumMax function

Description

Returns a BigNumber whose value is the maximum of the arguments.

Syntax

ajBigNumMax(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.

=ajBigNumMax({12, "13", 14})

The function returns 14 since it is the maximum number of the inputted array.

Example 2

Provide the number list in a range.

=ajBigNumMax(A1:C2)

The function returns 66 since it is the maximum number in the specified range.

Click here to download the use case workbooks for further reference.

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.