Skip to main content
LEAST

Returns the smallest value among the given columns (i.e., arguments)

Updated over a year ago

Description

The LEAST() function identifies and returns the smallest value from a set of columns (i.e., arguments) provided. It's useful for determining minimum values within datasets or scenarios where you need to select the lowest value.

Syntax

LEAST(arg1, arg2, ...)

Output

number

Variables

  1. arg1, arg2, ...: The numeric values or cell references you want to compare to find the smallest value.

Example

LEAST(`Quantity Sold - NY,``Quantity Sold - Boston`,`Quantity Sold - Newark`)

Product

Quantity Sold - NY

Quantity Sold - Boston

Quantity Sold - Newark

LEAST

Product A

150

140

20

20

Product B

280

320

50

50

Product C

500

100

320

100

Product D

90

120

320

90

Product E

120

30

20

20

Did this answer your question?