Blank Cells with Formulas

  • Thread starter Thread starter Kurt
  • Start date Start date
K

Kurt

I have a spreadsheet which I have formulas. I have formula
in blank columns waiting for me to input data that are
based off other formula. Until then it copies the value
of the last formula in the columns waiting for data.
 
Kurt

One method to take care of this is to enter an IF clause in your formulas.

=IF(cellvalue="","",cell*othercell)

Which equates to "if a cell is empty(or no value), show as blank, otherwise
show the formula result"

If you have trouble, post your formula and get more specific answers.

Gord Dibben Excel MVP
 
Kurt

I presume that you are after a culmulative total. If the
total is in column D then in D3

If(A3="","",C3+D2)

Regards
Peter
 
Back
Top