Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Avoiding the dreaded #div/0 error
Can I have advice on how to make the following formulae return a blank cell instead of a #div/0 error when the first reference cell in the formula is blank or 0? =E16/COUNTIF($C$29:$C$33,"M") in cell J21: =COUNTIF($H$42:$H$426,"A~*")/COUNT($J$42:$J$426) in cell F25: =SUM(J21:J24) Another rather annoying thing is that in cell A9 and A13 there is a 0 displayed. The formula in cell A9 is =E147 and in A13 it is E287. There is absolutely nothing in E147 or E287. I have tried everything I can think of to get A9 and A13 to remain blank instead of displaying a 0 (I may have typed something into E147 and E287 at one time to test it). Any ideas how to get rid of these zeros? -- Marie1uk ------------------------------------------------------------------------ Marie1uk's Profile: http://www.excelforum.com/member.php...o&userid=20984 View this thread: http://www.excelforum.com/showthread...hreadid=388599 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I prevent a #DIV/0! error from plotting on a chart | Charts and Charting in Excel | |||
replace "#DIV/0!" error with blanks | Excel Worksheet Functions | |||
# DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
"Average" with error DIV/0 | Excel Discussion (Misc queries) | |||
#DIV/0 Error | Excel Worksheet Functions |