D
Diddy
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(E8>0,H8>0),AVERAGE(E8,H8),SUM(E8,H8))
This works fine but is there a better way to do it?
Cheers
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(E8>0,H8>0),AVERAGE(E8,H8),SUM(E8,H8))
This works fine but is there a better way to do it?
Cheers