Average Sum needs blank if no info
On Jul 24, 9:25*am, Jim Thomlinson <James_Thomlin...@owfg-Re-Move-
This-.com wrote:
=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))
--
HTH...
Jim Thomlinson
Gave me an error. Err:508. if that helps
" wrote:
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
|