Thread: sums are wrong
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Desert Piranha Desert Piranha is offline
external usenet poster
 
Posts: 1
Default sums are wrong


Kevin Andrien Wrote:
I have two cells that contain functions that return numbers. The cells
are
formatted as numbers, and display as numbers. When I try to sum these
two
cells the answer is wrong. The SUM cell is also formatted as a
number.
Embarrassed to say I've been programming for 40 years and can't get by
this!Hi Kevin,


Without knowing any details, is Excel "rounding" the data that goes
into the SUM cell??


--
Desert Piranha


------------------------------------------------------------------------
Desert Piranha's Profile: http://www.excelforum.com/member.php...o&userid=28934
View this thread: http://www.excelforum.com/showthread...hreadid=573283