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

Informational Search 17
Select lowest value from 3 columns 7
using two functions in the same cell 6
Calculating value less minimum numbers in the sequence 4
ID Values 4
Subtraction Function using cells with other functions in them 2
Find the 10 lowest of 20 numbers in column and enter those 10 in a 14
Excel Concatenate with line breaks but ignore blank cells 3

Top