Multiple questions in a formula
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 |
All times are GMT +1. The time now is 08:33 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com