formula with {}
That's it! Great to know, thanks!
"Eduardo" wrote:
Hi
Edidt the formula, go to the cell where the formula is, press F2, then press
CTRL+SHIFT+ENTER
that will do the trick
"GeorgeA" wrote:
I have a formula that shows as:
{=A5-INDEX(A5:A400,MATCH(TRUE,K5:K4000,0))}
It works but I want to change it to:
{=A5-INDEX(A5:A400,MATCH(TRUE,J5:J400B6,0))}
Problem is that when I click to edit the formula, the {} brackets disappear
and then the formula returns $VALUE!.
Why do these brackets show up and how do I edit this formula?
Thanks, any help would be appreciated!
|