Thread: Excel incorrectly calculated a formula. Why? How?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
  
Posts: 4,339
Default Excel incorrectly calculated a formula. Why? How?
=C3-SUM(G1:G5)

" 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?
Reply With QuoteReply With Quote