formula lesser of

[Joanne]

I am looking for the formula for c1 = the lesser of a1 or
b1 for an excell spread sheet ?????

 

[Gord Dibben]

Joanne

=MIN(A1,B1)

Gord Dibben Excel MVP - XL97 SR2 & XL2002