Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas that may sometimes contain empty cells
How do you get a formula that contains empty cells to ingnore the formula and
return a value of 0 (zero) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas that may sometimes contain empty cells
Say we are adding A1 thru A10, but if any are blank, report 0 instead:
=IF(COUNTBLANK(A1:A10)0,0,SUM(A1:A10)) So you will see 0 until all the data is filled in. -- Gary''s Student - gsnu200829 "chrisnsmith" wrote: How do you get a formula that contains empty cells to ingnore the formula and return a value of 0 (zero) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formulas that may sometimes contain empty cells
Hi,
This really depends on the formula. In general cells that are empty are treated as 0. For example =SUM(A1:A10) returns 0 if all the cells are empty. On the other hand =AVERAGE(A1:A10) returns DIV/0 if all the cells are empty. In that case you could use =AVERAGEIF(A1:A10,"<") in 2007 or in 2003 IF(COUNT(A1:A10)0,AVERAGE(A1:A10),0) We need to see your formula. -- If this helps, please click the Yes button Cheers, Shane Devenshire "chrisnsmith" wrote: How do you get a formula that contains empty cells to ingnore the formula and return a value of 0 (zero) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formulas showing up in an empty cell by themselves | Excel Discussion (Misc queries) | |||
Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
When I SUM cells & 1 is empty I need the result to be empty not 0 | Excel Discussion (Misc queries) | |||
How can I convert empty strings to empty cells? | Excel Discussion (Misc queries) | |||
Empty space in formulas. | Excel Worksheet Functions |