98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » How to no when to use the ( etc
How to no when to use the ( etc
Resolved · High Priority · Version 2003
Anita has attended:
Excel Intermediate course
How to no when to use the ( etc
Do I have to use Customs formulas often and when?
RE: How to no when to use the ( etc
Hi Anita, Thank you for your post and welcome to the forum, I hope you enjoyed your course, in answer to your question; It very much depends on the way that you have to use Excel, using formulas is necessary if you want to manipulate the values you have in your Worksheet, if you are going to be writing your own formulas (ie custom formulas) you should consider the acronym BODMAS when you create your formula, BODMAS = Brackets, Ordinals, Division, Multiplication, Addition, Subtraction - this is the order in which Excel works out a formula's operators; Parentheses aka brackets.
Using brackets in your formulas is a good habit to get into even when they are not strictly needed because they help to clarify the order and make the formula easier to understand. It is also possible to put parentheses within parentheses. When parentheses are nested the ones on the inside are evaluated first.
When you enter parentheses you will notice that Excel tries to help you by making the matching parentheses bold as you pass over it with the mouse. Your parentheses must balance. For every open parentheses there must be a corresponding close parentheses.
If you try to submit a formula which does not contain the same number of open and close parentheses, Excel will prompt you and tell you that the formula you have entered is incorrect.
I hope that has made it a little clearer, if so, please click the resolved link, best regards Pete.
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Add Text to Displayed Numbers in Excel 2010To add text to a number in a cell, you need to go to the Home tab on the Ribbon, and click on the Cells group. Select Format Cells from the drop down menu then Custom from the Category list. In the Type box select General. After the word General, enter a space, then opening quotation marks, then the word you want to type and then closing quotation marks. Click on OK and you have your text! |