| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Divide by the minimum non-zero number in a range of cells
I need to find the minimum non-zero number in a range of cells that contains
some zeroes. So that I can divide by the minimum number. Any ideas? If I just use the MIN function, it returns a value of 0, then when my formula divides by that I get the divide by zero error. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding Minimum but if same number repeats in the range, then find | Excel Discussion (Misc queries) | |||
| Get a row number of range where a value is between minimum and max | Excel Worksheet Functions | |||
| Divide a range of cells by a number | Excel Discussion (Misc queries) | |||
| Return the minimum number in a range excluding zero | Excel Worksheet Functions | |||
| divide all numbers in range by a fixed number | Excel Discussion (Misc queries) | |||
Threaded Mode
