Dears:
I have a number 15. I need to devide it into 3 ratios: 33%, 50%, & 17%. I found 5.0, 7.5, & 2.5. Now I need to round these resultant numbers. If rounded, I found 5, 8, & 3 which summation is 16 grater than 15.
How and what function can I use to round these numbers which summation would be exactly 15?
Best regards,
MMH
Thank You,
Md Mukul Hossain
Hello mukul076,
Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks