sums are wrong
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! |
sums are wrong
Hi what means Wrong?
another result? #value? -- regards from Brazil Thanks in advance for your feedback. Marcelo "Kevin Andrien" escreveu: 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! |
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 |
sums are wrong
|
All times are GMT +1. The time now is 10:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com