| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
return a zero for error
I'm having a problem with a spreadsheet I'm developing which records average
marks of groups of students over several weeks. I want to display a "Running Average" of those averages as I enter the data, however, because I do this week by week there are inevitably weeks which have not had any data entered and her I see the error #DIV/0! for the formula =AVERAGE(IF(R5:R20<0, R5:R20,"")). I do understand why I'm getting this (because I'm dividing by zero) but would like to return a zero so that the average of the averages will return a number rather than an error. Can anybody help me? Pete |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Intervals of 1 Numeric value in a Row and Return Count down Column | Excel Worksheet Functions | |||
| Huge problem with "if" formula's | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| How do create a formula to evalute a # to return 1 of 4 conditions | Excel Worksheet Functions | |||
| if the value of a cell in a range is not blank, then return the v. | Excel Worksheet Functions | |||
Threaded Mode
