| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Formula for displaying in 1 cell Lowest value from multiple other cells
Doug
=MIN(A1:C200) Commit by shft-ctrl-enter (an array fomula) Beege wrote in message oups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Returning a cell's formula in a different cell | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Linear Mode
