| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
ARRAY FORMULA-RETURN 0 INSTEAD OF #DIV/0
Here is my array formula. I would like it to return a ZERO instead of
#DIV/0. Have spent way too much time trying to make it work and thought some kind soul out there would be willing to help me: {=AVERAGE(IF(H3:H6<0, H3:H6,""))} Thanks in advance! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to return tomorrow's date. | New Users to Excel | |||
| Array Formula | Excel Worksheet Functions | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
| What instead of an array formula part 2 | Excel Discussion (Misc queries) | |||
| What instead of an array formula? | Excel Discussion (Misc queries) | |||
Threaded Mode
