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 » Formulas including several calculations
Formulas including several calculations
Resolved · Low Priority · Version 2003
Konrad has attended:
Excel Intermediate course
Outlook Advanced course
Formulas including several calculations
Can formulas be manipulated in such a way that several calculations are included in them. If so what language should be used to describe square root, division, and what are there any rules that can help avoid making mistakes (this happens often for me and I have trouble figuring out where I went wrong).
Many Thanks and All the Best,
Konrad
RE: formulas
Hi Konrad,
Thank you for your post, welcome to the forum, in answer to your question, Excel allows nested formulas. In the case of the If function you can nest up to 7 If's in one go, if you want to be sure that your function names are correct; perhaps for a while you should use the fx button on the Formula bar, clicking on this button will open a dialog box which will allow you to choose the correct function, and give you the syntax that is required for that function. As for rules of creating functions and ensuring that they follow the correct sequence consider BODMAS, this is the sequence in which Excel performs nested functions and formulas. BODMAS stands for B = () Brackets, O = ^ Ordinals (to the power of) D = / Division, M = * Multiplication, A = + Addition and S = - Subtraction. Always remember that Excel will work from the deepest () first, so if you have more than one set of brackets in your formula, Excel will calculate the deepest set first.
I hope that has helped. If so please click the resolved link, 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:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |