| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with {}
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with {}
after you chang formuls dont just press enter. instead press
ctrl-shift-enter. this is call 'array-entering'. "GeorgeA" wrote in message ... |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! | |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with {}
The curly braces { } indicate that the formula is an "array
formula". To make a formula an array formula, you must press CTRL SHIFT ENTER rather than just ENTER when you first enter the formula and whenever you edit it later. You don't type in the braces; Excel puts them in automatically. See www.cpearson.com/Excel/ArrayFormulas.aspx for much more information about array formulas. Cordially, Chip Pearson Microsoft Most Valuable Professional, Excel, 1998 - 2010 Pearson Software Consulting, LLC www.cpearson.com On Wed, 19 May 2010 10:12:01 -0700, 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with {}
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
formula with {}
Thanks for the quick response!
"Homey" wrote: after you chang formuls dont just press enter. instead press ctrl-shift-enter. this is call 'array-entering'. "GeorgeA" wrote in message ... |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! | . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
