193.50 48.38 25%
106.43 55%
38.70 20%
Formula to multiply 193.50 by the percentages.....keep 193.50 constant.....and the MAIN issue is how to get the 3 results to add up to 193.50, not 193.51.
Thanks.
If you assume the cumulative % will always be 100% you could make the last equation a balancing figure, eg:
B3: =$A$1-SUM($B$1:$B$2)
where A1 is 193.50 and B1:B2 contain prior % allocations
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
Are the numbers you listed being displayed with two decimal points, or rounded to two decimal points? I put in 193.50 and your percentages and got the sum of the percentages to add up to 193.50.
If you have rounded those numbers, then you have guaranteed that you will have rounding error and no formula can save you. This is an inherent issue with doing arithmetic with rounded numbers and is not specific to Excel. You will see this all the time in magazines and newspapers, things like surveys where there is a footnote that percentages do not add up 100% due to rounding error.
If you want to avoid rounding error, do not round. But then you are getting into an issue regarding significant digits. That is another discussion.
Making the world a better place one fret at a time
||||||
If someone helped you, please click on the star icon at the bottom of their post
If your problem is solved, please update the first post:
EDIT, Go Advanced button, set Prefix to SOLVED
[code]
' Enclose code in tags like this
[/code]
Don't attach a screenshot--just attach your Excel file! It's easier and will let us experiment with your data, formulas, and code.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks