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!
|