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

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?

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

Hi Sherri,

=MIN(A1,B1)

HTH
--
AP

"sherri" a écrit dans le message de news:
...
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?

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

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

"Ardus Petus" wrote:

Hi Sherri,

=MIN(A1,B1)

HTH
--
AP

"sherri" a écrit dans le message de news:
...
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?