How to hide the symbol DIV/0

[Guest]

Hi,
On the cell D2 I'm looking for the average from data cell A2:C2. The formula I use like this: =average(A2:C2)

Problem: before I enter any value at cell A2:C2, on cell D2 it show the symbol DIV/0!
Question: how to hide or make the cell D2 do not show the symbol.

Thank you

 

[Guest]

Hi,

try this if(iserror(average(A2:C2)),0,average(A2:C2))

Regards,

Ashish Mathur

 

[Bob Phillips]

alternative

=IF(COUNTBLANK(A2:C2)=3,"",AVERAGE(A2:C2))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)