View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darryl Darryl is offline
external usenet poster
 
Posts: 7
Default Formula Question

Greetings,
I am now stuck trying to figure out a complex spreadsheet created by an
ex employee. If I click on Cell D34, I see the following in the formula bar
(while the cell appears empty):

{=SUM(IF(A50:A105=$D3,C50:C105))}

If I click on the formula in the formula bar to change from A105 to A120,
the
{} braces disappear and the formula appears in cell D34. Even if I retype
the
{} it still shows in the cell.

what is this and how do I change the formula while still having the cell
appear empty ?

thanks,
Darryl