View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sherri
 
Posts: n/a
Default 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?