Of course if we needed the answer to be 14 then we could have achieved that by using brackets Excel is still applying BODMAS but were forcing it to calculate in the order that we need so 46 2 3 -1 14 Excel starts with the innermost set of brackets works outwards so in this case Red then Blue then Green. If you need part of the calculation to be computed separately ignoring the DMAS rules you need to use brackets. Heres Excels order of operation with our highlighting.
As per BODMAS rule we have to calculate the expressions given in the brackets first.
According to Bodmas rules if expressions contains brackets like so in mathematics you have to first resolve the bracket and after that you will do division multiplication and addition and subtraction to get correct answers. Bodmas stands for brackets orders division multiplication addition subtraction. When evaluating a formula Excel follows a standard math protocol called order of operations. If you need part of the calculation to be computed separately ignoring the DMAS rules you need to use brackets.