software

Does anyone know how to set this up?
I have a worksheet with multiple columns. Each cell in these columns
has a differnt value. I am looking for a formula to display in 1 cell,
the lowest value from cells in the other 3 columns. I have heard of an
quot;ifquot; formaula, but can't find how to do this -
Anyone able to help?
Thanks- DougDoug

=MIN(A1:C200)

Commit by shft-ctrl-enter (an array fomula)

Beege

gt; wrote in message oups.com...
gt; Does anyone know how to set this up?
gt; I have a worksheet with multiple columns. Each cell in these columns
gt; has a differnt value. I am looking for a formula to display in 1 cell,
gt; the lowest value from cells in the other 3 columns. I have heard of an
gt; quot;ifquot; formaula, but can't find how to do this -
gt; Anyone able to help?
gt; Thanks- Doug
gt;