I’m looking for a method in Excel to automatically fill in a range of cells
(column A), given a value for the step and an end value. The calculations in
the adjacent column (B) are based on column A. Consequently, the range in
column B should automatically be adjusted to that of A. In the example below,
column A goes from 0.5 to 1 in steps of 0.1. The values in column B are
calculated from column A. If I adjust the step to 0.05, column A becomes 2
times longer and B should adjust automatically.
Can somebody help me with this?
Thanks,
Maarten
Initial value: 0.5
Step: 0.1
End: 1
A B
0.5 A1/SUM(A1:A6)
0.6 A2/SUM(A1:A6)
0.7 A3/SUM(A1:A6)
0.8 A4/SUM(A1:A6)
0.9 A5/SUM(A1:A6)
1 A6/SUM(A1:A6)
Re: Rounding Problem ... I would suggest that you NOT use the "Precision as displayed" setting. ... It can cause rather odd results in calculations if various cells have a different number of decimal places. ... Microsoft MVP - Excel... (microsoft.public.excel.newusers)
Re: Modify a conditional format formula in code? ...activecell, then excel will adjust the formula for the other rows. ... Try changing it to $N4 and when the other cells get their version of the formula ... And excel is pretty weird when it comes to using a relative reference in the ... (microsoft.public.excel.programming)
Re: Coping numbers to next blank cell on another worksheet ... > I am just learning Excel but any help would be> greatly appreciated. ... > I need to copy calculated numbers in> specific cells on worksheet # 1 to the next blank cells in existing> columns of numbers used in calculations on other worksheets in the same> workbook. ... While the orginial number comes from the same cell> each time the destination for each number must go to the next blank cell> in the same column and on the same worksheet each time. ... (microsoft.public.excel)
Conditional formatting formula behavior ...Excel is resetting row references to row 1 when a new row is inserted. ... This is not how the same formulas (but in cells) are adjusted when rows ...Adjust differently when a new row 32 is inserted. ... (microsoft.public.excel)
Coping numbers to next blank cell on another worksheet ... My OS is XL Professional and I have MS Excel 2002 SP2. ... specific cells on worksheet # 1 to the next blank cells in existing ... columns of numbers used in calculations on other worksheets in the same ... in the same column and on the same worksheet each time. ... (microsoft.public.excel)
