Description | The |
Syntax | LEAST( |
Output | number |
Variables
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 |