Excel incorrectly calculated a formula. Why? How?
What is in C3 and G1:G5?
" wrote:
I tried this and still get the same wrong answer of 0.
"Elkar" wrote:
Try writing it like this:
=C3-SUM(G1:G5)
HTH,
Elkar
" wrote:
my formula says =sum(C3-(G1:G5))
It comes up and says 0, when it should say 149.26
HELP
" wrote:
Excel incorrectly calculated a formula. Why, how do I fix it?
|