View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default Formula for displaying in 1 cell Lowest value from multiple other cells

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
"if" formaula, but can't find how to do this -
Anyone able to help?
Thanks- Doug