ExcelBanter - How do I compare two cells and display the lesser of the two cell.

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How do I compare two cells and display the lesser of the two cell. (https://www.excelbanter.com/excel-worksheet-functions/147528-how-do-i-compare-two-cells-display-lesser-two-cell.html)

cshives

How do I compare two cells and display the lesser of the two cell.

PCLIVE

How do I compare two cells and display the lesser of the two cell.

One way:

=MIN(A1,A2)

HTH,
Paul

"cshives" wrote in message
...

Toppers

How do I compare two cells and display the lesser of the two cell.

=MIN(A1,B1)

"cshives" wrote in message
...

All times are GMT +1. The time now is 02:25 PM.