software

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- DougHi

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.

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