Solved

Excel97 addition problem using ROUNDOWN function

Posted on 2002-07-17
1
343 Views
Last Modified: 2007-12-19
I have a situation where I need to add cells together whose results have been calculated using the roundown function. For example: 6.8 gets roundown to 6 and 5.3 gets roundown to 5. When I add them together I want to get 11, but I'm getting 12. Any ideas? Certainly would appreciate any help I can get.

Thanks
0
Comment
Question by:dluhyt
1 Comment
 
LVL 7

Accepted Solution

by:
ildc earned 100 total points
ID: 7159834
Instead of using the rounddown, use the int() function if you do not want any decimals in it. This works as you want it.

Regards
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort has a feature called the "Send To Bar". It provides a convenient, drag-and-drop interface for using other installed software, such as Microsoft Office. However, this article shows that the latest Office 2016 apps (installed with an Office …
Outlook Free & Paid Tools
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question