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

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
bodmas

ResolvedVersion 2007

Katrina has attended:
Excel Introduction course
Word Intermediate course

BODMAS

Not sure of this..how is =A1+B1*C1 equal 7?

RE: BODMAS

Hi Katrina, Thank you for your post, welcome to the forum, I hope you enjoyed the Excel 2007 intro course, in answer to your question, and a good one it is too; BODMAS stands for Brackets, Ordinals (raised to the power of), Division, Multiplication, Addition and Subtraction, this is the sequence that Excel (and Access) follow when calculating, in the case that you have mentioned the figures in the cells will be considered by Excel and calculated in the order laid down by BODMAS, in this case because Multiplication comes before Addition it will calculate B1*C1 and then add A1 to the value, so where A1 = 1 B1 = 2 and C1 = 3, 3*2=6 +1 = 7. Its all down to the sequence that Excel follows. I hope that helped, if it did please click the resolved button, hope to see you again on the forum soon, best regards Pete.

Excel tip:

Repeating headings on spreadsheets that print on more than one page

By default when you print a spreadsheet out and it prints on more than one page, the headings at the top and the side of the spreadsheet don't appear on all the pages following page 1.

To get Excel to repeat headings on all pages when printing, go to File - Page Setup - Sheet, then select the rows to repeat at the top of pages, and the columns to repeat at the side of pages by clicking on the red arrows at the right side of the two boxes under the 'Print titles' area. Then click OK.

If you view your spreadsheet in Print Preview, you should see the headings being repeated on each page.

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.1 secs.