Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
=IF(C7=0,"",AVERAGE(H7:H11)) - doesn't work
=IF(C7=0,"",AVERAGE(H7:H11))
This formula is not working and I am not sure what I am doing wrong. I want the cell to remain blank and not show an error message when the related cells are blank. It is blank when the other cells are empty but it stays blank even when I enter values into the other cells. Probably a simple fix but I can't get it to work. All help is appreciated. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
How to get saved old saved work that was saved over? | Excel Discussion (Misc queries) |