View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] conwaydawg@gmail.com is offline
external usenet poster
 
Posts: 3
Default Average Sum needs blank if no info

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