MIN3D

Returns the smallest value in a range of cells in the whole workbook.

MIN3D is very similar to the MIN function of Microsoft Excel. The main difference is that MIN3D considers all worksheets, while the original MIN function doesn't.

Syntax

MIN3D(range_input, include_current)

range_input - is the range for which you want to find out the smallest value.

include_current - Optional. Boolean argument , either TRUE or FALSE. Decides whether the current worksheet is included in the function's consideration. TRUE means the current worksheet will be considered, and vice versa.

Remarks