Formula parentheses [SOLVED]
- Thread starter Excel
- Start date
SirJB7
Excel Rōnin
@b(ut)ob(ut)hc
Hi, old dog!
Good very late at night or very early in the morning for you.
Absolutely, it was a sort of joke since I don't have an English keyboard as I use one with Spanish international layout, so my symbols on shift of numbers are: 1-!, 2-", 3-nothing(Alt-Gr-3, #), 4-$, 5-%, 6-&, 7-/, 8-(, 9-), 0-=...
It was just a joke, but anyway thanks, my friend.
Regards!
Hi, old dog!
Good very late at night or very early in the morning for you.
Absolutely, it was a sort of joke since I don't have an English keyboard as I use one with Spanish international layout, so my symbols on shift of numbers are: 1-!, 2-", 3-nothing(Alt-Gr-3, #), 4-$, 5-%, 6-&, 7-/, 8-(, 9-), 0-=...
It was just a joke, but anyway thanks, my friend.
Regards!
SirJB7
Excel Rōnin
Hi, Excel!
First of all and despite of all previous, welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about questions in general...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
And about this question in particular...
If you're referring to parenthesis or British brackets "(" & ")" you actually deserve what was posted before.
If you're asking for square or American brackets "[ & ]" and you don't happen to find them in the keyboard just use Alt-091 & Alt-093.
Now if you're asking (and I guess you're) for curly brackets "{" & "}" and you neither happen to find them in the keyboard just use Alt-123 & Alt-125. But, if you're looking at a formula embraced into curly brackets, there's another stuff:
a) Normal formulas: =<expression> and are entered with the Enter key.
b) Array formulas: {=<expression>} and are entered without the curly brackets but with Ctrl-Shift-Enter instead of Enter.
Regards!
First of all and despite of all previous, welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about questions in general...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, like the following one(s) -if any posted below-, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
And about this question in particular...
If you're referring to parenthesis or British brackets "(" & ")" you actually deserve what was posted before.
If you're asking for square or American brackets "[ & ]" and you don't happen to find them in the keyboard just use Alt-091 & Alt-093.
Now if you're asking (and I guess you're) for curly brackets "{" & "}" and you neither happen to find them in the keyboard just use Alt-123 & Alt-125. But, if you're looking at a formula embraced into curly brackets, there's another stuff:
a) Normal formulas: =<expression> and are entered with the Enter key.
b) Array formulas: {=<expression>} and are entered without the curly brackets but with Ctrl-Shift-Enter instead of Enter.
Regards!
Thank you SirJB7.
Hi, I am Sameer, an accountant. I did research but did not find the answer hence I have posted this question.
Is there anyway we can add brackets at the beginning and end of a long array formulas with some function key.
I mean if I want to multiply below formula with 1.5
formula 1 + formula 2 + formula 3 and want to open bracket at the beginning of formula 1 and close at the end of formula 3.
Is there any functional key which can do it rather than manual work of Shift+9/0.
Hi, I am Sameer, an accountant. I did research but did not find the answer hence I have posted this question.
Is there anyway we can add brackets at the beginning and end of a long array formulas with some function key.
I mean if I want to multiply below formula with 1.5
formula 1 + formula 2 + formula 3 and want to open bracket at the beginning of formula 1 and close at the end of formula 3.
Is there any functional key which can do it rather than manual work of Shift+9/0.
bobhc
Excel Ninja
Good day Sameer
Some of the so called short cuts can involve more key pressing than the actual keys needed to do it the long way,, there is not much shorter then shift + the ( or ) key (two key press), regonal diffrences may make a slight diffrence as SirJB7 has pointed out in his post. Excel is good but still needs the user to input, I belive mind reading is sheduled for version 2050..
Some of the so called short cuts can involve more key pressing than the actual keys needed to do it the long way,, there is not much shorter then shift + the ( or ) key (two key press), regonal diffrences may make a slight diffrence as SirJB7 has pointed out in his post. Excel is good but still needs the user to input, I belive mind reading is sheduled for version 2050..
SirJB7
Excel Rōnin
Hi, Excel!
Nothing at all, and as b(ut)ob(ut)hc pointed out a shortcut for a two-key press isn't a useful shortcut.
But don't get confused with curly brackets of array formulas: they're only set and it's done automatically when you enter the formula with Ctrl-Shift-Enter, and you can't enter them manually.
Regards!
Nothing at all, and as b(ut)ob(ut)hc pointed out a shortcut for a two-key press isn't a useful shortcut.
But don't get confused with curly brackets of array formulas: they're only set and it's done automatically when you enter the formula with Ctrl-Shift-Enter, and you can't enter them manually.
Regards!