MIN

Formula Explanation

The MIN formula is used in conjunction with the FIND formula to find the minimum value among a set of data objects.

Formula Syntax

Result column input: min(find(target column number, condition, maximum length to return array))

Usage Example

Find the minimum value of column DN2 in the DN table among the values in column DM3 of the DM table, with the condition DM2=DN2. Write the result in column DN3.

DN3 = min(find(dm3, dn2=dm2, 5))

min

Last Updated: