japc90 wrote:
=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.

Hi japc90,

To see the AVERAGE(H7:H11) in the cell with your formula, you have to input
a value in C7.

If you want to see the blank if all the cells are blank and the result of
AVERAGE(H7:H11) if C7<0 or the cells in the range H7:H11 have a value, you
can use this formula:

=IF(and(C7=0,iserror(AVERAGE(H7:H11))),"",AVERAGE( H7:H11))

--
(I'm not sure of names of menus, options and commands, because
translating from the Italian version of Excel...)

Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy