View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
japc90 japc90 is offline
external usenet poster
 
Posts: 58
Default =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.