What function should I use

[Bonnie]

Say I have three columns with different numbers. These numbers may go up or
they may go down. I want to be able to choose a function and have it find the
lowest number out of the three colums.

Column 1 Column 2 Column 3
215 185 398

I want the function to choose the middle because it is the lowest.
But next week the lowest might be in column 3.

 

[John]

Try this
=MIN(A1:C255) adjust range to your needs.
HTH
John

 

[Mike H]

hi

=Min(a1:a3)

Mike

 

[muddan madhu]

=SMALL(A1:C1,2)

 

[Glenn]

Say I have three columns with different numbers. These numbers may go up or
they may go down. I want to be able to choose a function and have it find the
lowest number out of the three colums.

Column 1 Column 2 Column 3
215 185 398

I want the function to choose the middle because it is the lowest.
But next week the lowest might be in column 3.

Look at "MIN worksheet function" in the help file.