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
