Table formulas

[The Original IronMan]

How do I formulate or what formula(s) do I need to apply to a table so that when I change a number in a single box outside of the formatted table, all the number inside the formatted table change relative to the value in the single box??

 

[Toadstool]

Hi TheOriginalIronMan,

I'm not sure what you mean by box so I've assumed cell.

TheOriginalIronMan.xlsx
	E	F	G	H	I
1	Factor		No1	No2	No3
2	444		548.41525	1.2351695	888
3			528.53516	1.1903945	1332
4			515.01441	1.1599424	1776
5			505.22236	1.1378882	2220
6			497.80349	1.121179	2664
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=[@No2]*$E$2
H2:H6	H2	=$E$2/([@No3]+1000)+1
I2:I6	I2	=$E$2*ROW()

 

[The Original IronMan]

Hi TheOriginalIronMan,

I'm not sure what you mean by box so I've assumed cell.

TheOriginalIronMan.xlsx
	E	F	G	H	I
1	Factor		No1	No2	No3
2	444		548.41525	1.2351695	888
3			528.53516	1.1903945	1332
4			515.01441	1.1599424	1776
5			505.22236	1.1378882	2220
6			497.80349	1.121179	2664
Sheet1

Cell Formulas
Range	Formula
G2:G6	G2	=[@No2]*$E$2
H2:H6	H2	=$E$2/([@No3]+1000)+1
I2:I6	I2	=$E$2*ROW()

Hi Toadstool,
Yes! I meant cell - bad habit of calling them boxes!!
Thanks for the quick reply and help. I’ll follow your example and get back to you with the results ??