Can someone help me figure out why Excel is calculating the function in the attached file incorrectly? I have been using Excel for years and have never had this problem before.
Can someone help me figure out why Excel is calculating the function in the attached file incorrectly? I have been using Excel for years and have never had this problem before.
What do you expect the results to be?
?????
=SUM(D3-(A3+B3)*C3)
remove the pointless SUM
=D3-(A3+B3)*C3
substitute
= 2.30 - (2.08 + 0) * 50,000
= 2.30 - 2.08 * 50,000
= 2.3 - 10,4000
= -103997.7
Exactly as expected.
Yep, it looks correct to me.
In what way is it wrong?
The only thing I can think of that might be making it result differently than you want is due to the order of calculations.
It's not 'Wrong', just differrent from what you expected.
Remove the SUM as Ben said, it's useless in that formula.
=D2-(A2+B2)*C2
It does A2+B2 First
A2=2.08
B2=0
So A2+B2 = 2.08
=D2-(2.08)*C2
This might be where it's working differently than what you want.
Excel does (2.08)*C2 first.
Perhaps you want it to do D2-(2.08) first.
If that's the case, you need an extra set of parens around that part to force Excel to do that part first.
=(D2-(A2+B2))*C2
I expect the result to be 11000
In that case you messed up your algebra; adding the parens like Jonmo hypothesized will deliver 11,000.
Jonmo1
Thank You for the reply. Your suggestion was exactly correct, and provides the desired result.
Thank You
You're welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks