formula to select lowest value

J

jcheko

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

Fred Smith

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

=min(a1:a3)

Regards,
Fred.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell color if used in a formula? 0
Showing the top result from a range of cells 6
Newbie Help - IF Yes No Function 0
difference between the lowest and next lowest value 5
formula help... lookup or ref? 2
Subtracting Values from a Ranked List 7
remove lowest 2 values in a row? 2
Drop down list control value in vba 2

Top