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.

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.12 secs.