leave cells blank until formula applied
Perhaps the formula refers to that cell through absolute addressing
(i.e. with $ symbols before the row and column references)
Perhaps your workbook is set to Manual calculation - use Tools |
Options | Calculation tab to set it to automatic.
Perhaps you want your formula to do something like this:
=IF(cell_ref="","",your_formula)
or:
=IF(cell_ref="",0,your_formula)
But we can't really tell as you have not given us the formula that you
are using.
Pete
On Jul 10, 6:29*pm, Rita wrote:
I have a spreadsheet with simple calculation formulas in the columns and one
of the columns with the same formula copied and pasted into each cell is
driving me crazy! I just want the cells to be either blank or have a zero
but, instead, the value from the top cell is in all of them. I didn't past
the values only the formula. Am I missing something in the formula or in the
formatting of those cells? *Help Please!
--
Rita
|