bodmans

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

• Home
• Courses
• Promotions
• Schedule
• Formats
• Our Clients

# Bodmans

Resolved · Medium Priority · Version 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...

Wed 19 Jun 2013: Automatically marked as resolved.

Training courses

Training information:

 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 What does 'Resolved' mean? Any suggestions, questions or comments? Please post in the Improve the forum thread.

### Adding multiple rows in an Excel 2010 Worksheet

If you want to add more than one row to an Excel Worksheet, drag select the number or rows you want added to the spreadsheet.

Then right click on these selected rows, choose Insert from the menu, and the new rows will be added above the rows you first selected.

View all Excel hints and tips