Programming a column so the it displays the lesser of two values

  • Thread starter Thread starter NLB
  • Start date Start date
N

NLB

I want to program a column so that each cell of that column will choose as
the value it displays the lesser of the values in two other columns. What
formula will do that?

Thanks much!
 
If column A & B are the two columns you want to compare, then put this in C1
and copy down

=min(A1,B1)

This will treat blanks as 0 though - if you want to ignore blanks then use
this:

=min(if(isblank(A1),B1,A1),if(isblank(B1),A1,B1))
 
I want to program a column so that each cell of that column will choose as
the value it displays the lesser of the values in two other columns. What
formula will do that?

Thanks much!
Click to expand...

Yeah that works - but be careful about adding too many statements in one cell. For some reason the min() function wasn't working properly when i combined it into a larger line of functions. I had to break it out separately and then all worked well.
 
Back
Top