Display of formula result

[KerriBarsh]

Is it possible to have a formula result not display unless all data is entered?

For example: (A1+A2)+2, the result is always displayed as "2" until cells
A1 and A2 are given values.

I need the results cell to remain empty until A1 and A2 are filled in.

Is this possible in Excel 2003?

Thanks!

 

[Roger Govier]

Hi Kerri

various ways of achieving this
Try
=IF(COUNT(A1:A2)<2,"",A1+A2+2)

 

[KerriBarsh]

Thanks so much, Roger! Your suggestion worked perfectly!