bodmas

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

TrustPilot

starstarstarstarstar Excellent

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

Forum home » Delegate support and help forum » Microsoft Excel Training and help » BODMAS

BODMAS

resolvedResolved · Low Priority · Version 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:

Moving between Worksheets without using the mouse

Use the 'Ctrl+PgDn' and 'Ctrl+PgUp' keys.

'Ctrl+PgDn' will move to the right and 'Ctrl+PgUp' will move to the left one worksheet at a time.

View all Excel hints and tips


Server loaded in 0.08 secs.