Westonci.ca makes finding answers easy, with a community of experts ready to provide you with the information you seek. Join our Q&A platform and get accurate answers to all your questions from professionals across multiple disciplines. Connect with a community of professionals ready to help you find accurate solutions to your questions quickly and efficiently.
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
Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. We appreciate your visit. Our platform is always here to offer accurate and reliable answers. Return anytime. We're dedicated to helping you find the answers you need at Westonci.ca. Don't hesitate to return for more.