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
|