Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Sum needs blank if no info
=if(and(max(B3;D3;F3)=0, min(B3;D3;F3)=0), "", average(B3;D3;F3))
-- HTH... Jim Thomlinson " 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Sum needs blank if no info
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...) " wrote: 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 -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Sum needs blank if no info
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)) ;429151 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 -- p45cal *p45cal* ------------------------------------------------------------------------ p45cal's Profile: http://www.thecodecage.com/forumz/member.php?userid=558 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=119239 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Sum needs blank if no info
Got the answer right he
=IF(B3=0;0;AVERAGEA(B3;E3;H3)) Thanks guys! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Issue with dynamic chart mapping out blank info | Excel Worksheet Functions | |||
How to copy info into blank cells within a column (going up the co | Excel Discussion (Misc queries) | |||
Macro ?-moving info from 1 sheet to first blank section on another | Excel Discussion (Misc queries) | |||
Average Formula to display blank cell if named range is blank | Excel Worksheet Functions | |||
insert info only if cell is blank (Max from Singapore ref) | Excel Discussion (Misc queries) |