Display of formula result
 

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!

Display of formula result
 

Hi Kerri

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


--

Regards
Roger Govier

"KerriBarsh" wrote in message
...
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!

Display of formula result
 

Thanks so much, Roger! Your suggestion worked perfectly!

"Roger Govier" wrote:

Hi Kerri

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


--

Regards
Roger Govier

"KerriBarsh" wrote in message
...
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!