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
|