K
Kevin from Belleview Florida
What are the Charcters "{}" used for in a Beginning of a formula and at the
end of a formulain Excel 2003.
end of a formulain Excel 2003.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
K
Kevin B
The left/right brace indicate an array formula. After the formula is entered
press Ctrl+Shift+Enter to place the braces around the formula.
The braces are not typed.
press Ctrl+Shift+Enter to place the braces around the formula.
The braces are not typed.
K
Kevin B
I forgot to state this in the previous post.
For an excellent introduction to array formulas check out the following URL:
http://www.cpearson.com/excel/ArrayFormulas.aspx
Chuck Pearson has an excellent website containing a wealth of information
regarding using Excel.
For an excellent introduction to array formulas check out the following URL:
http://www.cpearson.com/excel/ArrayFormulas.aspx
Chuck Pearson has an excellent website containing a wealth of information
regarding using Excel.
G
Gord Dibben
So has Chip Pearson at the same website<g>
Gord Dibben MS Excel MVP
Gord Dibben MS Excel MVP
K
Kevin B
Gee, you don't think Chuck, uhh, I meant Chip, will be offended do you?
G
Gord Dibben
My take on Chip is that he doesn't offend that easily.
You're not the first to mis-name him and get corrected.
Or maybe you are but forgot<g>
Gord
You're not the first to mis-name him and get corrected.
Or maybe you are but forgot<g>
Gord