Smaller of two diff cells

G

Gord Dibben

Sandy

=MIN(A9,A2) entered in B1

BTW: makes it easier if you refer to cells by their address rather than by
Cell 9 or Cell 2

Gord Dibben Excel MVP
 
Top