| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Formula Not Working
I have tried two different formulas to Average / Median a column of % here
are the two formulas, =IF(ISERROR(AVERAGE(M4:M50)),0,(AVERAGE(M4:M50)) or =IF(ISERROR(MEDIAN(M4:M50)),0,MEDIAN(M4:M50)) Neither of them worked correctly. The ISERROR is in place to deal with cells that are linked and do not show a % until other information is completed. If the source cell goes unused the column maintains the ERROR, so the cell with the formula has to see the error as 0 or blank to generate the average. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula not working | New Users to Excel | |||
| Again for Formula that isn't working... | Excel Worksheet Functions | |||
| IF OR formula not working | Excel Discussion (Misc queries) | |||
| Formula is not working | Excel Discussion (Misc queries) | |||
| Sum formula not working | Excel Worksheet Functions | |||
Threaded Mode
