| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#NUM! being returned instead of 0 or blank
I was told to use the formula below which allows the lowest number within a
range to be displayed discounting any zeros, this works fine. =SMALL(D51:H51,COUNTIF(D51:H51,"<=0")+1) The new problem that I am now having is that this is reliant upon a value being present with which to calculate otherwise "#NUM!" is being returned. Is there a way in which I can get the around this and have the returned value a 0 or just blank? The subsequent retuned value is then referenced into a column but because "#NUM!" is displayed the column will not add together. Thank you -- Yorkie |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return Summed Count of Multiple Consecutive Numeric Values | Excel Worksheet Functions | |||
| Sumif Cells Are Not Blank | Excel Worksheet Functions | |||
| CONCATENATE problem with blank cells | Excel Discussion (Misc queries) | |||
| How to delete blank rows | Excel Discussion (Misc queries) | |||
| blank cells | Excel Discussion (Misc queries) | |||
Threaded Mode
