Does anyone know this formula ? lowest value shows in a cell

D

Doug_montgomery

I have a sheet with 3 columns. Each of the 3 columns has values in the
cells. I want the lowest of these 3 values to appear in a 4th column,
and even on a cell in a different worksheet as a 2nd part to the
question. Does anyone know the formula to achive this?

Help appreciated- Doug
 
G

Guest

Hi

This:
=MIN(A2:C2)
will give you the minimum of the three cells. You can copy this down the
column.
If you just want the minumum of the whole of the three columns, use
=MIN(A:C)
If you want to use more than one sheet, you could use
=MIN(MIN(sheet1!A:C),MIN(sheet2!A:C))

Andy.
 
Top