| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
What is wrong with this formula?
I am trying too average some test scores and sometimes one of those numbers
can be zero. I read that the AVERAGE function will ignore blank cells, so I tried to use an IF statement to change the zeros to blank cells. Here is what I tried. =AVERAGE(IF(D109:F109=0,"",D109:F109)) Any help would be greatly appreciated. Thanks Greg Ruff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| adding row to forumla | Excel Discussion (Misc queries) | |||
| Formula retrieves wrong data | Excel Discussion (Misc queries) | |||
| Recalculating Formula - Getting the wrong answers | Excel Discussion (Misc queries) | |||
| Wrong answer after using the payment formula in excel | New Users to Excel | |||
| What wrong with VLOOKUP formula | Excel Worksheet Functions | |||
Threaded Mode
