What function should I use

B

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.
 
G

Glenn

Bonnie said:
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.
Click to expand...


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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel - Wich Function should I use? 1
Problem with SET & REF function 0
Select minimum with duplicate values to return column headings 3
Select lowest value from 3 columns 7
Insert Index into a Table 1
Subtraction Function using cells with other functions in them 2
Informational Search 17
using two functions in the same cell 6

Top