- #1
mrdane
- 9
- 0
Hopefully somebody here can clue me into figuring out a math problem.
I'd like to create an Excel spreadsheet that will allow me to enter my numbers and have it calculate the results, but I'm not sure how to do the calculation (or for that matter, perhaps how to enter it into Excel...) So here goes:
This is an example: I have a total sum of 98.61 made up from two numbers 62.89 and 35.71 What I'd like to do is vary the amounts but preserve the relationship (ratios, percentages?) between the numbers. The purpose is to round out my add-in numbers to nice round figures (like 50 or 25 or 30 or 125 or whatever as long as the they come out as nice round figures.) The resulting sum of 98.61 can vary up or down as much as needed. The ratio between the numbers can vary a bit (I can accept some degree of variation) but ideally not too much.
The Excel formula would then allow me to perform the same calculation on a set of three other numbers (and possibly a sum of 3 or 4 add-ins.)
For someone doing calculations all day, this is probably a remedial calculation but I would appreciate the help.
Anyone want to point me in the right direction?
TIA!
I'd like to create an Excel spreadsheet that will allow me to enter my numbers and have it calculate the results, but I'm not sure how to do the calculation (or for that matter, perhaps how to enter it into Excel...) So here goes:
This is an example: I have a total sum of 98.61 made up from two numbers 62.89 and 35.71 What I'd like to do is vary the amounts but preserve the relationship (ratios, percentages?) between the numbers. The purpose is to round out my add-in numbers to nice round figures (like 50 or 25 or 30 or 125 or whatever as long as the they come out as nice round figures.) The resulting sum of 98.61 can vary up or down as much as needed. The ratio between the numbers can vary a bit (I can accept some degree of variation) but ideally not too much.
The Excel formula would then allow me to perform the same calculation on a set of three other numbers (and possibly a sum of 3 or 4 add-ins.)
For someone doing calculations all day, this is probably a remedial calculation but I would appreciate the help.
Anyone want to point me in the right direction?
TIA!
Last edited: