| Home |
| Search |
| Today's Posts |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,
it worked, thank you.
-- Jignesh, JP "smartin" wrote: Jignesh wrote: 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, Wrap the function with an error trap, like =IF(ISERROR(AVERAGE(IF(F30:F69=3,O30:O69,"0")),0,A VERAGE(IF(F30:F69=3,O30:O69,"0"))) |
| 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) | |||
Threaded Mode
