View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
KerriBarsh KerriBarsh is offline
external usenet poster
 
Posts: 2
Default 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!