SOLVED

Excel wrong calculation

Copper Contributor

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.

 

Excel calculation error.png

3 Replies
best response confirmed by Robert Vilhelmsen (Copper Contributor)
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

@Robert Vilhelmsen

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
1 best response

Accepted Solutions
best response confirmed by Robert Vilhelmsen (Copper Contributor)
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

View solution in original post