Hi,

Average ignores blanks cell so

=AVERAGE(E8,H8)

does what you want.

Mike

"Diddy" wrote:

Hi everyone,

I'm using the following formula to average the values of 2 cells. If either
is empty, I want it to return the value in the non-blank cell.

=IF(AND(E80,H80),AVERAGE(E8,H8),SUM(E8,H8))

This works fine but is there a better way to do it?

Cheers
--
Diddy