View Single Post
  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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