How do I compare values of two cells and display the lowest.

sherri · Jun 21, 2006

I would like Excel to compare the values in two cells and display the value
that is lowest of the two. Is there a formula to do that?

Ardus Petus · Jun 21, 2006

Hi Sherri,

=MIN(A1,B1)

HTH

sherri · Jun 21, 2006

Thank you! I knew it must be easy to do, but I just couldn't find it in
Help. Thanks again!