Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rounding parts of a number while maintaining the Total
I have a column of numbers which need to be split into between 1-4 new
columns based on percentage values stored in my worksheet if rngPercents = A1:A4 and rngNumbers=D2:D373 I need Col E=rngPercents(1,1)*rngNumbers Col F=rngPercents(2,1)*rngNumbers Col G=rngPercents(3,1)*rngNumbers Col H=rngPercents(4,1)*rngNumbers Now the problem I need the values in Cols E-H to be whole numbers which will still total the Original Numbers in Col D This involves rounding and for the life of me I can't come up with a method that will ensure the correct totals I am willing to use VBA or formulas to accomplish this Some Math Wizard must have done this before and your help will be greatly appreciated. Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining Number Formats from Excel to CSV File Conversions | Excel Discussion (Misc queries) | |||
Maintaining Row Number | Excel Discussion (Misc queries) | |||
find parts of a total | Excel Worksheet Functions | |||
Maintaining Number Colors | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |