creating a blank formula cell

  • Thread starter Thread starter Stephen
  • Start date Start date
S

Stephen

I am trying to create a sheet which has a number in cell a1 and another
number in cell b1 and in cell c3 the sum, however i want cell c3 to stay
empty until b1 is filled.

I used to have this on a old spreadsheet but cannot find out how to do this
on excel 2007

Regards

Stephen Brown
 
THank you for that. I do remember that in my old sheet it hid the formula,
also even if i choose show formula it still was blank in the cells if there
was no calculation.

Regards

Stephen Brown
 
Back
Top