Formula that can pick the lowest value

[Excelboo2]

I have "50" in cell(1,1), and "70" in cells(1,2). Is there any formular that I can set in cell(1,3) to pick the lowest value, ie in this case "50" , automatically? Thanks

 

[Richard Schollar]

=min(a1:b1)

 

[DonkeyOte]

=MIN(value1,value2)

where value1, value2 can be cell references.

 

[Chantty]

U Can use min formula logic for this:-

=MIN(A1:B1)

 

[Excelboo2]

Thanks, is there any similar function that I can use in VBA?

 

[Richard Schollar]

Application.WorksheetFunction.Min()