I have three cells S, T, U with vales 7,2,8
I want to look at all three cells and put the lowest value (T) in col Z
How can I do it in one formula?
Thanks

Hi

In the cell in column Z type
=MIN(S:U)
or if there is actual cells rather than the whole column
=MIN(S1:U1)
these will put the lowest value in the cell

if it's the cell reference of the lowest value you're after use
=CELL("address",INDEX(S1:U1,MATCH(MIN(S1:U1),S1:U1 ,0)))


Cheers
JulieD


"Have three columns R,S,T" <Have three columns
wrote in message
...
I have three cells S, T, U with vales 7,2,8
I want to look at all three cells and put the lowest value (T) in col Z
How can I do it in one formula?
Thanks

Hi,

Try:

=Min(S1:U1)

---
Regards,
Norman



"Have three columns R,S,T" <Have three columns
wrote in message
...
I have three cells S, T, U with vales 7,2,8
I want to look at all three cells and put the lowest value (T) in col Z
How can I do it in one formula?
Thanks

S,T and U are not cell addresses.

S1, T1 and U1 are cell addresses.

In Z1 enter =MIN(S1:U1)

Gord Dibben Excel MVP

On Sat, 4 Dec 2004 08:09:04 -0800, "Have three columns R,S,T" <Have three
columns wrote:

I have three cells S, T, U with vales 7,2,8
I want to look at all three cells and put the lowest value (T) in col Z
How can I do it in one formula?
Thanks