Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2017? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - strange caclulatinos
strange caclulatinos
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases
View previous topic :: View next topic  
Author Message
socrbob
Sentinel


Joined: Oct 13, 2007
Posts: 23

PostPosted: Mon May 26, 2008 4:05 pm    Post subject: strange caclulatinos Reply with quote

Please explain this, I have my number format set to 2 decimals, for the sheet, I get the following numbers from a calculation; 2.25, 2.00, 1.27, and 1.17 when I sum them with the sum function I get 6.68. I have a sum for each additional number, all is correct until the final addition of 5.52 + 1.17. If I type the numbers in a different column, I get 6.69. Question Please advise, thanks
Back to top
View user's profile Send private message
pluby
The Architect
The Architect


Joined: Jun 16, 2003
Posts: 11887
Location: California, USA

PostPosted: Mon May 26, 2008 5:55 pm    Post subject: Reply with quote

You have set your cell format to two decimal places. However, I suspect that the real values in those cells is more than two decimal places so with the two decimal formatting, you only see the first two decimals places and the rest are not shown. The formula that sums these cells, however, uses the full value of the cell.

If you want each cell value to be rounded to two decimal places, you need to have each cell use the ROUND() formula.

Patrick
Back to top
View user's profile Send private message Visit poster's website
socrbob
Sentinel


Joined: Oct 13, 2007
Posts: 23

PostPosted: Tue May 27, 2008 5:08 pm    Post subject: Reply with quote

Thank you, that did the trick! Very Happy
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Releases All times are GMT - 7 Hours
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.03 Seconds