| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Handling #NUM! error
Good afternoon gurus,
I created a formula in a spreadsheet that returns the followin g error #NUM! I have 4 zero values in C662:F662 and the formula I created in G662 is =SMALL(C662:F662,COUNTIF(C662:F662,0)+1) How could I modify the formula to avoid the #NUM! error display... I tried the formula if(erro.type... in G662 but got no success! Help is more than welcome Be well Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error handling in macro | Excel Discussion (Misc queries) | |||
| Error handling in a search | Excel Discussion (Misc queries) | |||
| Error handling in this code | Excel Discussion (Misc queries) | |||
| Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
| Error Handling for "my" menu bar | Excel Discussion (Misc queries) | |||
Threaded Mode
