ExcelBanter - formula to select lowest value

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - formula to select lowest value (https://www.excelbanter.com/excel-discussion-misc-queries/225488-formula-select-lowest-value.html)

jcheko

formula to select lowest value

I need a formula so it can select the lowest value of three cells...thanks in
advance for your help.

Fred Smith[_4_]

formula to select lowest value

It's called the Min function (yes, sometimes Excel is logical). As in:

=min(a1:a3)

Regards,
Fred.

"jcheko" wrote in message
...
I need a formula so it can select the lowest value of three cells...thanks
in
advance for your help.

LowdenPicker

formula to select lowest value

=MIN(A1:A3)

"jcheko" wrote:

I need a formula so it can select the lowest value of three cells...thanks in
advance for your help.

All times are GMT +1. The time now is 09:17 PM.