Aug 25 2021 05:05 AM
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.
Aug 25 2021 05:10 AM
Solution@Robert Vilhelmsen 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
Aug 25 2021 05:10 AM
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
Aug 25 2021 05:10 AM
Solution@Robert Vilhelmsen 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