@RMIN

Calculate the minimum value for a row.

Syntax

@RMIN(t1, [nt2], [nt3])

Argument	Description
t1	A row code for the row to find the minimum. The row can be in the current or another spreadsheet. The string can be empty ("") to default to the base data cell of the current row.
nt2	Optional Start period name, number or column code for range to find the minimum. Default is the period or column.
nt3	Optional End period name, number or column code for range to find the minimum. Default is the last period unless processing the current row when it is assumed to be the column preceding the formula.

Argument

Description

A row code for the row to find the minimum. The row can be in the current or another spreadsheet. The string can be empty ("") to default to the base data cell of the current row.

nt2

Optional

Start period name, number or column code for range to find the minimum.

Default is the period or column.

nt3

Optional

End period name, number or column code for range to find the minimum.

Default is the last period unless processing the current row when it is assumed to be the column preceding the formula.

Logic

The function finds the minimum of values in a spreadsheet row given a start and end column. the function ignores subtotal columns.

Examples

@RMIN("Row01", "Jan2023", "Mar2023")

s@RMIN("", 1, 3)

@RMIN("Row01", 4)

@RMIN("Row01")