Average Sum needs blank if no info

[conwaydawg]

OK. I am ver ynew to excel and my boss wants me to create a fileto
gather her info in.

=AVERAGEA(B3;D3;F3)

Thats my formula i have figured out and got done. But on the days i
have no info yet it shows #DIV/0!, I figure this is for an error
meaning no data has been entered yet.

How can I have that show up blank until data is entered?

thanks

 

[Jim Thomlinson]

=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))

 

[conwaydawg]

=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))

Gave me an error. Err:508. if that helps

 

[Dave Peterson]

I bet Jim uses a comma for his list separator.

And he was being very nice when he used semi-colons in his suggested
formula--but he missed a couple of commas (fingers KNOW what to type <vbg>).

Try changing those 2 commas to semicolons.

(although I'm not sure what that 508 error is...)

 

[p45cal]

how about
=IF(ISERROR(AVERAGEA(B3,D3,F3)),"",AVERAGEA(B3,D3,F3))
and with semicolons:
=IF(ISERROR(AVERAGEA(B3;D3;F3)),"",AVERAGEA(B3;D3;F3))

 

[conwaydawg]

Got the answer right here:

=IF(B3=0;0;AVERAGEA(B3;E3;H3))


Thanks guys!