Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Error
Hi All,
I have a formula that gives the correct result but has an error in the cell before any data has been entered into the other cells. Formula: =AVERAGE(F43:G43) Error: #DIV/0! How can I eliminate this error please. Thank you for your assistance. Ken. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Error
Ken, here is one way,
=IF(ISERROR(AVERAGE(F43:G43)),"",AVERAGE(F43:G43)) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ken Grady" wrote in message ... Hi All, I have a formula that gives the correct result but has an error in the cell before any data has been entered into the other cells. Formula: =AVERAGE(F43:G43) Error: #DIV/0! How can I eliminate this error please. Thank you for your assistance. Ken. |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Error
Another way:
=IF(COUNT(F43:G43)<0,AVERAGE(F43:G43),"") Paul, I am fascinated by COUNT() so I try to use COUNT(). If you see a problem, please let me know. Trying to learn here. Epinn "Paul B" wrote in message ... Ken, here is one way, =IF(ISERROR(AVERAGE(F43:G43)),"",AVERAGE(F43:G43)) -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Ken Grady" wrote in message ... Hi All, I have a formula that gives the correct result but has an error in the cell before any data has been entered into the other cells. Formula: =AVERAGE(F43:G43) Error: #DIV/0! How can I eliminate this error please. Thank you for your assistance. Ken. |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Error
Thanks for the help these reply's fixed the problem.
Ken. Hi All, I have a formula that gives the correct result but has an error in the cell before any data has been entered into the other cells. Formula: =AVERAGE(F43:G43) Error: #DIV/0! How can I eliminate this error please. Thank you for your assistance. Ken. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ODCB Error 1919 and ODCB Error 6 | Setting up and Configuration of Excel | |||
error bars display | Charts and Charting in Excel | |||
Error bars-repost | Charts and Charting in Excel | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
#REF error | Excel Worksheet Functions |