| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average when No Data
I use this formula:
=AVERAGE(IF(ISNUMBER(I7:AQ7);I7:AQ7)) When there is no data in the range, the formula returns DIV/0. Is there a way to modify the formula so that it returns """ instead of DIV/0. Thank you in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Two data sets, one average | Charts and Charting in Excel | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
