View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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!