I am trying to create a table??? The letter "A" is a number entered by myself between 25-46, 27 in this example then B1= 362.522 - B2 (a percent ,EX 2%) = 355.271...... C1=the same value in D 362.522 - C2 (2.5%)=352.458 all the way through Z1 I hope I explained this well. If anyone could help that would be great. Thanks! Co-efficient:A 27CelsiusDegrade YearDegradeRemaining B 25365.000 1B2 2%B1 C 26363.759 2C2 2.5%C1 D 27362.522 3D2 3%D1 E 28361.290 4E2 4%E1 F 29360.061 5F2 4.5%F1 G 30358.837 6G2 5%G1 H 31357.617 7H2 5.5%H1 I 32356.401 8I2 6%I1 J 33355.189 9J2 6.5%J1 K 34353.982 10K2 7%K1 L 35352.778 11L2 7.5%L1 M 36351.579 12M2 8%M1 N 37350.383 13N2 8.5%N1 O 38349.192 14O2O1 P 39348.005 15P2P1 Q 40346.822 16Q2Q1 R 40345.642 17R2R1 S 42344.467 18S2S1 T 43343.296 19T2T1 U 44342.129 20U2U1 V 45340.966 21V2V1 W 46339.806 22W2W1 23X2X1 24Y2Y1 25Z2Z1

DaveM790 =VLOOKUP($B$1,$E$3:$F$24,2,FALSE)*(1-B3/100)Is this what you are looking for?

Copper Contributor

Feb 25, 2022

Solved

HELP creating a table of some type

I am trying to create a table??? The letter "A" is a number entered by myself between 25-46, 27 in this example then B1= 362.522 - B2 (a percent ,EX 2%) = 355.271...... C1=the same value in D 362.522 - C2 (2.5%)=352.458 all the way through Z1 I hope I explained this well. If anyone could help that would be great. Thanks!

		Co-efficient:	A 27
Celsius	Degrade	Year	Degrade	Remaining
B 25	365.000	1	B2 2%	B1
C 26	363.759	2	C2 2.5%	C1
D 27	362.522	3	D2 3%	D1
E 28	361.290	4	E2 4%	E1
F 29	360.061	5	F2 4.5%	F1
G 30	358.837	6	G2 5%	G1
H 31	357.617	7	H2 5.5%	H1
I 32	356.401	8	I2 6%	I1
J 33	355.189	9	J2 6.5%	J1
K 34	353.982	10	K2 7%	K1
L 35	352.778	11	L2 7.5%	L1
M 36	351.579	12	M2 8%	M1
N 37	350.383	13	N2 8.5%	N1
O 38	349.192	14	O2	O1
P 39	348.005	15	P2	P1
Q 40	346.822	16	Q2	Q1
R 40	345.642	17	R2	R1
S 42	344.467	18	S2	S1
T 43	343.296	19	T2	T1
U 44	342.129	20	U2	U1
V 45	340.966	21	V2	V1
W 46	339.806	22	W2	W1
		23	X2	X1
		24	Y2	Y1
		25	Z2	Z1

Formulas and Functions

OliverScheurich
Feb 25, 2022
DaveM790
=VLOOKUP($B$1,$E$3:$F$24,2,FALSE)*(1-B3/100)
Is this what you are looking for?
celsius degrade.pdf192 KB

Forum Discussion

HELP creating a table of some type

4 Replies

Resources