Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells
Using Excel 2007. I am using this basic formula in the H column
=SUM(H2,C3)-F3 in a spreadsheet with financial information. I copied and pasted the formula into the entire H column. The last entry, for example, might be in cell H6. From H7 on down the column, the calculation in H6 is displayed. Is there something simple that can be added to keep the cell calculation empty until data is entered into the other cells used in the formula? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Blank cells
=IF(COUNT(H2,C3,F3)=3,H2+C3-F3,"")
This will check to make sure numbers are entered in all relevant cells before performing calculation. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "deannab" wrote: Using Excel 2007. I am using this basic formula in the H column =SUM(H2,C3)-F3 in a spreadsheet with financial information. I copied and pasted the formula into the entire H column. The last entry, for example, might be in cell H6. From H7 on down the column, the calculation in H6 is displayed. Is there something simple that can be added to keep the cell calculation empty until data is entered into the other cells used in the formula? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Index/match - make blank cells return a blank value. | Excel Worksheet Functions | |||
Excel 2002: Return blank when VLOOKUP on blank cells | Excel Discussion (Misc queries) | |||
Nested IF - return a blank when compared cells are blank | New Users to Excel | |||
Maximum Number of Blank Cells between Non Blank Cells in a Range | Excel Worksheet Functions | |||
Imported Data creates blank cells that aren't really blank | Excel Worksheet Functions |