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))

"NLB" wrote:

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!

On Tuesday, July 21, 2009 11:25:00 AM UTC-4, NLB wrote:
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!

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.