Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

bodmans

ResolvedVersion 2010

Louise has attended:
Excel Introduction course

Bodmans

I am terrible @ maths is there any esier way to break down the formula to get the correct answer :(

RE: Bodmans

Hello Louise,

Hope you enjoyed your Microsoft Excel Introduction course with Best STL.

Thank you for your question regarding breaking down a formula to get the correct answer. In order to know how to create formulas with greater understanding it is essential to know the order in which Excel does the calculations.

Excel performs calculations in a specific order.

First, anything inside a set of round brackets is calulated and stored.

Secondly, Excel will look for any exponents in your formula and take the stored result from the first calculation and perform the exponent calculation which is then stored.

Thirdly, Excel will take the latest stored value and calculate any divisions and/or multiplications (in any order) and store the result.

Finally, Excel will take the latest stored value and calculate any additions and/or subtractions which become the final result which goes into a cell where you are entering the formula.

There are times when you need to add some data together before multiplying or dividing by another value. Since adding is in the fourth position you have to let Excel know that the addition calculation must be done first. To achieve this all you have to do is put round brackets on either side of the cell references being added. Excel will calculate this first and then perform the multiplication or division.

I have attached a file with explanations and a couple of examples which should help you understand the order of calculations.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer

Attached files...

Bedmas.xlsx

Wed 19 Jun 2013: Automatically marked as resolved.

Excel tip:

Wrapping Text in a Cell in an Excel 2010 Workbook

When you have a lot of text you want to put in a particular cell but you can't decrease the font size to fit because the text will then become ineligible, then manually wrap the text in a cell by simply pressing ALT+ENTER.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.