Creating relationships between cells using formulas, functions, or something else??

[Brendo714]

Hello everyone, I am new here to this forum! First post . Here is the issue I am having that I need help with: I have 4 columns with many, many rows of data. I am trying to figure out a way to get the numbers in 3 columns to auto update when I change the number in the first column. For example, if I have A1=1, B1=2, C1=3, D1=4, and I change A1 from 1 to a 2, I would like the remaining three columns to auto update(B1=4, C1=6, D1=8). Or for another example, if I changed A1 from 1 to .5, I would want the remaining three columns to auto update to B1=1, C1=1.5, D1=2. How do I go about doing this, do I need to utilize a formula, function, or something else?? Also, if there is a solution, can I mass apply it to all of the other rows of data I have? So that, for example, cells B2 C2 D2 would change if I changed A2, and B3 C3 D3 would change with A3 and so on...?? Thanks!!

[David A Coop]

Am I oversimplifying this?

In B1 enter the formula =A1*2
In C1 enter the formula =A1*3
In D1 enter the formula =A1*4

You can then copy down as far as you like.

If you want one formula which you can copy across and down =$A1*COLUMN()
because you are always looking a column A and multiplying by the column number.

I hope this helps, please let me know!

Regards,

David

If this has been helpful
- Please click on the *Add Reputation button at the bottom left.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".

[FDibbins]

If you only have 1 (variable) value in A and B:D can contain formulas, then David's suggestion should work for you - PROVIDED the relationship is always as you have given in the examples

If there are actual values in B:D that you want to have changed, then you cannot do this with formulas, you would need VBA

[FDibbins]

Deleted my duplicate post

[FDibbins]

Deleted my duplicate post

[FDibbins]

Deleted my duplicate post