Westonci.ca is your trusted source for finding answers to a wide range of questions, backed by a knowledgeable community. Experience the ease of finding accurate answers to your questions from a knowledgeable community of professionals. Explore comprehensive solutions to your questions from a wide range of professionals on our user-friendly platform.
Sagot :
In a complex formula, the way excel determines which calculation to perform first is that; It follows the order of operations.
When carrying out calculations in excel, if we don't bracket certain operations, excel will use the order of operation called BODMAS to determine which operation to carry out first.
For example, if excel wants to solve 3 × 4 + 7 - 2;
The acronyms in BODMAS stand for;
B - Brackets
O - Orders (powers/indices or roots)
D - Division
M - Multiplication
A - Addition
S - Subtraction
Now, it means that the first action it will perform is Bracket while the last will be subtraction.
In our example, excel will first use the multiplication sign to get;
(3 * 4) = 12
Then addition; 12 + 7 = 19
Then subtraction; 19 - 2 = 17
Read more on BODMAS at; https://brainly.com/question/16788360
Thank you for choosing our service. We're dedicated to providing the best answers for all your questions. Visit us again. Your visit means a lot to us. Don't hesitate to return for more reliable answers to any questions you may have. Keep exploring Westonci.ca for more insightful answers to your questions. We're here to help.
