Select lowest value from 3 columns
 

Hi,

I am trying to create a formula to select the lowest number from three
columns and input it into a fourth. For example:

Column A: 5
Column B: 3
Column C: 7
Column D: 3 (Formula result)

I know how to do this for two columns with an 'IF' function but this is now
too complicated for me.
Any help is appreciated.
Thanks.

Select lowest value from 3 columns
 

Try this:

=MIN(A1:C1)

--
Biff
Microsoft Excel MVP


"ub67" wrote in message
...
Hi,

I am trying to create a formula to select the lowest number from three
columns and input it into a fourth. For example:

Column A: 5
Column B: 3
Column C: 7
Column D: 3 (Formula result)

I know how to do this for two columns with an 'IF' function but this is
now
too complicated for me.
Any help is appreciated.
Thanks.

Select lowest value from 3 columns
 

=MIN(A:A,B:B,C:C)
--
Gary''s Student - gsnu200836

Select lowest value from 3 columns
 

=MIN(A2,B2,C2)
--
David Biddulph

"ub67" wrote in message
...
Hi,

I am trying to create a formula to select the lowest number from three
columns and input it into a fourth. For example:

Column A: 5
Column B: 3
Column C: 7
Column D: 3 (Formula result)

I know how to do this for two columns with an 'IF' function but this is
now
too complicated for me.
Any help is appreciated.
Thanks.

Select lowest value from 3 columns
 

Thank you!

"Gary''s Student" wrote:

=MIN(A:A,B:B,C:C)
--
Gary''s Student - gsnu200836

Select lowest value from 3 columns
 

Thank you!

"T. Valko" wrote:

Try this:

=MIN(A1:C1)

--
Biff
Microsoft Excel MVP


"ub67" wrote in message
...
Hi,

I am trying to create a formula to select the lowest number from three
columns and input it into a fourth. For example:

Column A: 5
Column B: 3
Column C: 7
Column D: 3 (Formula result)

I know how to do this for two columns with an 'IF' function but this is
now
too complicated for me.
Any help is appreciated.
Thanks.

Select lowest value from 3 columns
 

You're welcome!

--
Biff
Microsoft Excel MVP


"ub67" wrote in message
...
Thank you!

"T. Valko" wrote:

Try this:

=MIN(A1:C1)

--
Biff
Microsoft Excel MVP


"ub67" wrote in message
...
Hi,

I am trying to create a formula to select the lowest number from three
columns and input it into a fourth. For example:

Column A: 5
Column B: 3
Column C: 7
Column D: 3 (Formula result)

I know how to do this for two columns with an 'IF' function but this is
now
too complicated for me.
Any help is appreciated.
Thanks.

Select lowest value from 3 columns
 

=MIN(A:A,B:B,C:C)

Or:

=MIN(A:C)


--
Biff
Microsoft Excel MVP


"Gary''s Student" wrote in message
...
=MIN(A:A,B:B,C:C)
--
Gary''s Student - gsnu200836