Forum Discussion
Solved
Excel wrong calculation
Hi, What is wrong here since the calculation should be 2000? Excel 16.0.14131.20278) 32-bit on Windows 10 21H1 all updastes installed.
RVilhelmsen you've got the wrong formula... Excel has calculated correctly using BODMAS
For your answer to be 2000 you would need the formula to be =(E11-F11)*G11
Multiplication has precedence above subtraction, so 200-100*20 is evaluated as 200-(100*20) = 200-2000 = -1800.
If you want to force Excel to subtract first, you must use parentheses to specify the calculation order:
=(E11-F11)*G11
See The order in which Excel performs operations in formulas
Thank you