I want to multiply a number say, 1551 by 5%, 6%, 7%, 8% and 9% and round each result to 0 decimal places. Then the sum of these results (544)should be equal to 35% of 1551 rounded to 0 decimal places (543). How do I create an if function for rounding so that the sum equals 543.
Last edited by dittotharappel; 03-28-2009 at 12:06 PM.
I think your math is off. Multiplying that number gives me the final answer:
=ROUND(SUM(N2:R2),0)
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Maybe like this:
The formula in C3 and copied down is =IF( B3 = 0, 0, ROUND( ($C$1 - SUM(C$2:C2) ) * B3 / ($B$8 - SUM(B$2:B2)), 0) )Please Login or Register to view this content.
Entia non sunt multiplicanda sine necessitate
That works fine. But it would be better if the modification happens for the least decimal value for a rounddown and for the highest decimal value for a roundup. In the given function the modification happens to the last number.
That may be true for the example, but is not in general. But by all means, change however you wish.In the given function the modification happens to the last number.
Thanks shg, that saves me a lot of time and trouble.
You’re welcome. Would you please mark the thread as Solved?
Click the Edit button on your first post in the thread
Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks