View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default What function should I use

Try this
=MIN(A1:C255) adjust range to your needs.
HTH
John
"Bonnie" wrote in message
...
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.