Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
What are the Charcters "{}" used for in a Beginning of a formula and at the
end of a formulain Excel 2003. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
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. -- Kevin Backmann "Kevin from Belleview Florida" wrote: What are the Charcters "{}" used for in a Beginning of a formula and at the end of a formulain Excel 2003. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
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. -- Kevin Backmann "Kevin from Belleview Florida" wrote: What are the Charcters "{}" used for in a Beginning of a formula and at the end of a formulain Excel 2003. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
So has Chip Pearson at the same website<g
Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 11:23:02 -0700, Kevin B wrote: Chuck Pearson has an excellent website containing a wealth of information regarding using Excel. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
Gee, you don't think Chuck, uhh, I meant Chip, will be offended do you?
-- Kevin Backmann "Gord Dibben" wrote: So has Chip Pearson at the same website<g Gord Dibben MS Excel MVP On Wed, 3 Oct 2007 11:23:02 -0700, Kevin B wrote: Chuck Pearson has an excellent website containing a wealth of information regarding using Excel. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
What are the Charcters "{}" used for
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 On Wed, 3 Oct 2007 14:11:02 -0700, Kevin B wrote: Gee, you don't think Chuck, uhh, I meant Chip, will be offended do you? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |