| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculation to ignore a 0 (zero) value
I have a series of calculations that I need to use the MIN formula. the
problem is that many of the cells can have a 0(zero) value and not just blank. Is there a way to find the minimum value but ignore the 0's? Otherwise the minimum is always 0. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| use "button" to make calculation ignore a cell | Excel Worksheet Functions | |||
| Ignore errors when calculation average of multiple ranges | Excel Worksheet Functions | |||
| Can a calculation ignore text if it occurs in formula's cell range | Excel Worksheet Functions | |||
| Calculation Setting in Excel | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Threaded Mode
