High Value

Returns the highest value for last PERIOD time periods.

Syntax:

HighValue
HighValue()
HighValue(“Period”)
HighValue(“OutPutStartCell”,”Period”)

Inputs:

'High' column values

Parameters:

• Period (default=14)
• OutPutStartCell (default=the next blank column in the worksheet)

Examples:

HighValue
HighValue()
HighValue(“14”)
HighValue(14)
HighValue(“G2”,”14”)
HighValue(“G2”, 14)
HighValue(G2,”14”)
HighValue(G2, 14)