| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Remove the #DIV/0!
I am using the formula:
=AVERAGE(D4:D13,H4:H13,L4:L13) in Cell D15. But when there is NO data in those cells, how can i set the formual above to display NOTHING rather than "#DIV/0!" ? Corey.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the #DIV/0!
Remove the cause, in those cells with the errors change the formula
=IF(A2=0,"",A1/A2) replace with your data accordingly -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Corey" wrote in message ... I am using the formula: =AVERAGE(D4:D13,H4:H13,L4:L13) in Cell D15. But when there is NO data in those cells, how can i set the formual above to display NOTHING rather than "#DIV/0!" ? Corey.... |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the #DIV/0!
Thanx.
Ended up with: =IF(SUM(D4:D13,H4:H13,L4:L13)<0,AVERAGE(D4:D13,H4 :H13,L4:L13),"") Corey.... "Peo Sjoblom" wrote in message ... Remove the cause, in those cells with the errors change the formula =IF(A2=0,"",A1/A2) replace with your data accordingly -- Regards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com (Remove ^^ from email) "Corey" wrote in message ... I am using the formula: =AVERAGE(D4:D13,H4:H13,L4:L13) in Cell D15. But when there is NO data in those cells, how can i set the formual above to display NOTHING rather than "#DIV/0!" ? Corey.... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Remove the #DIV/0!
May be better to have
=IF(COUNT(D4:D13,H4:H13,L4:L13)<0,AVERAGE(D4:D13, H4:H13,L4:L13),"") then you can cope with the case where the total, and therefore the average, is zero. -- David Biddulph "Corey" wrote in message ... Thanx. Ended up with: =IF(SUM(D4:D13,H4:H13,L4:L13)<0,AVERAGE(D4:D13,H4 :H13,L4:L13),"") "Peo Sjoblom" wrote in message ... Remove the cause, in those cells with the errors change the formula =IF(A2=0,"",A1/A2) replace with your data accordingly "Corey" wrote in message ... I am using the formula: =AVERAGE(D4:D13,H4:H13,L4:L13) in Cell D15. But when there is NO data in those cells, how can i set the formual above to display NOTHING rather than "#DIV/0!" ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| remove a name | Excel Discussion (Misc queries) | |||
| Remove ÿ | Excel Discussion (Misc queries) | |||
| how to remove #DIV/0! | Excel Worksheet Functions | |||
| Remove AM PM | Excel Discussion (Misc queries) | |||
| REMOVE #N/A | Excel Worksheet Functions | |||
Hybrid Mode
