Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Excel97 addition problem using ROUNDOWN function

Posted on 2002-07-17
1
Medium Priority
?
349 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 400 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
In this post, I will showcase the steps for how to create groups in Office 365. Office 365 groups allow for ease of flexibility and collaboration between staff members.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

916 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