creating a blank formula cell

[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

 

[Don Guillett]

=IF(LEN(TRIM(K5))<1,"",SUM(J5:K5))

 

[Stephen]

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

 

[Don Guillett]

Where is your old sheet. Perhaps a worksheet_change event macro