Return lowest figure from three columns

[preveo]

Hi,

I have numbers in A1, B1, C1. What formula do I use in D1, to return the lowest number found in A1, B1, C1?

Kind regards

Ben

[PaulM100]

Try:

=MIN(A1:C1)

[JohnTopley]

Try

=MIN(A1:C1)

[63falcondude]

FYI, you can also use =SMALL(A1:C1,1)

If you want to find the nth smallest, change 1 to n.