Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0")
I am using =AVERAGE(IF(F30:F69=3,O30:O69,"0")). Also using CSE to {}.
In Column F30 to F69 i have value 1-10. Some cells are blanks. In Column O30 to O69 I have a calcuation based on Column L and N. When there is a Number 3 in Column F, raw30-69 and some value in Column O raw 30-69, I am getting average of those value, but when number 3 is not present in Column F raw 30-69, i am getting #DIV/0. How do i get 0 instead of #DIV/0. Can amy one help me? -- Jignesh, JP |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
how can I avoid "server busy" message during ole automation | Excel Discussion (Misc queries) | |||
Avoid "update Links" promt in e-mailed pivot tables? | Excel Discussion (Misc queries) | |||
How do I avoid "Missing PDFMaker files" error? | Excel Discussion (Misc queries) | |||
Text formatted as "General" in Excel 2002. How do I avoid that? | Excel Discussion (Misc queries) |