Quick way to fill a formula?

[mrbeige]

Hi, so I have a specific formula (A2) for which I have identified each variables which I listed in the table bellow. I want to know if there is a way for me to quickly assign each value of A, each value of B, etc so that I can get a complete formula for cases 1 to 5? Thanks a lot!

Contrats calculs.xlsx
	A	B	C	D	E	F	G
1
2	Et=(A*(IPCt-1/IPC2003))+(B*(IPCMES/IPC2003)*FTI)+(C*(ACIER/D)*FTI)+E*(IPCUSMES/IPCUS2003)*(TCUS/F)*FTI)
3
4	FTI = ((13,098579*((i(1+i)^20)/((1+i)^20-1))-1)*0,5+1
5
6		1	2	3	4	5
7	A	12,64	12,92	11,8	11,08	13,62
8	B	35,27	33,45	42,57	38,15	39,3
9	C	4,59	4,87	4,74	4,09	3,97
10	D	97,2	97,2	97,2	97,2	97,2
11	E	22,95	24,34	14,21	12,26	11,91
12	F	1,29	1,29	1,29	1,29	1,29
13	i	0,04212609	0,04212609	0,0369176	0,0287745	0,0287745
14	FTI	0,99102427	0,99102427	0,96884695	0,93524247	0,93524247
15	IPCt-1
16	IPC2003	102,8	102,8	102,8	102,8	102,8
17	IPCMES	107	107	111,5	116,5	116,5
18	STEEL	124,823077	124,823077	143,607692	150,069231	150,069231
19	IPCUSMES	116,792308	116,792308	124,191769	129,198385	129,198385
20	IPCUS2003	107,758333	107,758333	107,758333	107,758333	107,758333
21	TCUS	0,88299125	0,88299125	0,8586385	0,98279475	0,98279475
22
Variables AO1 (2)

Cell Formulas
Range	Formula
B13:F13	B13	='Taux rendement'!E8/100
B14:F14	B14	=(((13.098579*(B13*((1+B13)^20))/(((1+B13)^20)-1))-1)*0.5)+1
B16:F16	B16	='IPC 2003-2023'!$B$18
B17:F17	B17	='IPC 2003-2023'!B23
B18:F18	B18	='IPC Acier'!B56
B19:F19	B19	='IPC (US)'!F6
B20:F20	B20	=AVERAGE('IPC (US)'!$B$39:$B$50)
B21:F21	B21	='Taux change'!F7

 

[felixstraube]

The variable ACIER is not defined

 

[felixstraube]

I gave it the value 1, then would this work?:

Libro2
	A	B	C	D	E	F
1
2	Et=(A*(IPCt-1/IPC2003))+(B*(IPCMES/IPC2003)*FTI)+(C*(ACIER/D)*FTI)+E*(IPCUSMES/IPCUS2003)*(TCUS/F)*FTI)	53,42442399	52,5745966	55,4574909	51,0551413	51,9985575
3
4	FTI = ((13,098579*((i(1+i)^20)/((1+i)^20-1))-1)*0,5+1
5
6		1	2	3	4	5
7	A	12,64	12,92	11,8	11,08	13,62
8	B	35,27	33,45	42,57	38,15	39,3
9	C	4,59	4,87	4,74	4,09	3,97
10	D	97,2	97,2	97,2	97,2	97,2
11	E	22,95	24,34	14,21	12,26	11,91
12	F	1,29	1,29	1,29	1,29	1,29
13	i	0,04212609	0,04212609	0,0369176	0,0287745	0,0287745
14	ACIER	1	1	1	1	1
15	FTI	0,99102427	0,99102427	0,96884695	0,93524247	0,93524247
16	IPCt-1	1	1	1	1	1
17	IPC2003	102,8	102,8	102,8	102,8	102,8
18	IPCMES	107	107	111,5	116,5	116,5
19	STEEL	124,823077	124,823077	143,607692	150,069231	150,069231
20	IPCUSMES	116,792308	116,792308	124,191769	129,198385	129,198385
21	IPCUS2003	107,758333	107,758333	107,758333	107,758333	107,758333
22	TCUS	0,88299125	0,88299125	0,8586385	0,98279475	0,98279475
Hoja1

Cell Formulas
Range	Formula
B2:F2	B2	=LET(A,B7,B,B8,C,B9,D,B10,E,B11,F,B12,i,B13,ACIER,B14,FTI,B15,IPCt_1,B16,IPC_2003,B17,IPCMES,B18,STEEL,B19,IPCUSMES,B20,IPCUS2003,B21,TCUS,B22, A*IPCt_1/IPC_2003 + B*IPCMES/IPC_2003*FTI + C*ACIER/D*FTI + E*IPCUSMES/IPCUS2003*TCUS/F*FTI )