Hello everyone,
I have the following table in excel:
HA0.300.350.400.450.500.550.6020.3900.4330.4730.5090.5430.5730.58730.2740.3090.3420.3740.4060.4370.46640.2070.2350.2610.2890.3180.3460.3744.50.1830.2080.2320.2580.2850.3110.33950.1640.1870.2090.2320.2580.2870.31060.1350.1540.1720.1920.2140.2360.26170.1140.1300.1450.1630.1770.2020.22480.0980.1120.1260.1400.1540.1750.19590.08590.09810.11060.12330.13570.15430.1723100.07630.08730.09860.10960.12070.13750.1540110.06870.07860.08870.09880.10880.12400.1385 _________________H______________________
A 0.30 0.35 0.40 0.45 0.50 0.55 0.60
2 0.390 0.433 0.473 0.509 0.543 0.573 0.587
3 0.274 0.309 0.342 0.374 0.406 0.437 0.466
4 0.207 0.235 0.261 0.289 0.318 0.346 0.374
4.5 0.183 0.208 0.232 0.258 0.285 0.311 0.339
5 0.164 0.187 0.209 0.232 0.258 0.287 0.310
6 0.135 0.154 0.172 0.192 0.214 0.236 0.261
7 0.114 0.130 0.145 0.163 0.177 0.202 0.224
8 0.098 0.112 0.126 0.140 0.154 0.175 0.195
9 0.0859 0.0981 0.1106 0.1233 0.1357 0.1543 0.1723
10 0.0763 0.0873 0.0986 0.1096 0.1207 0.1375 0.1540
11 0.0687 0.0786 0.0887 0.0988 0.1088 0.1240 0.1385
H (0.3-0.6) and A (2-11), in the middle factors correlate A and H at the same time. I use the FORECAST function to find any value of A let us say 4.6 but just correspond to certain value of H $C$3
=FORECAST(F15,OFFSET($C$3,MATCH(F15,$B$3:$B$16,1)-1,0,2),OFFSET($B$3,MATCH(F15,$B$3:$B$16,1)-1,0,2))
Could you help me to find a formula to find the factor for any A and H values.
Best Regards
I have the following table in excel:
HA0.300.350.400.450.500.550.6020.3900.4330.4730.5090.5430.5730.58730.2740.3090.3420.3740.4060.4370.46640.2070.2350.2610.2890.3180.3460.3744.50.1830.2080.2320.2580.2850.3110.33950.1640.1870.2090.2320.2580.2870.31060.1350.1540.1720.1920.2140.2360.26170.1140.1300.1450.1630.1770.2020.22480.0980.1120.1260.1400.1540.1750.19590.08590.09810.11060.12330.13570.15430.1723100.07630.08730.09860.10960.12070.13750.1540110.06870.07860.08870.09880.10880.12400.1385 _________________H______________________
A 0.30 0.35 0.40 0.45 0.50 0.55 0.60
2 0.390 0.433 0.473 0.509 0.543 0.573 0.587
3 0.274 0.309 0.342 0.374 0.406 0.437 0.466
4 0.207 0.235 0.261 0.289 0.318 0.346 0.374
4.5 0.183 0.208 0.232 0.258 0.285 0.311 0.339
5 0.164 0.187 0.209 0.232 0.258 0.287 0.310
6 0.135 0.154 0.172 0.192 0.214 0.236 0.261
7 0.114 0.130 0.145 0.163 0.177 0.202 0.224
8 0.098 0.112 0.126 0.140 0.154 0.175 0.195
9 0.0859 0.0981 0.1106 0.1233 0.1357 0.1543 0.1723
10 0.0763 0.0873 0.0986 0.1096 0.1207 0.1375 0.1540
11 0.0687 0.0786 0.0887 0.0988 0.1088 0.1240 0.1385
H (0.3-0.6) and A (2-11), in the middle factors correlate A and H at the same time. I use the FORECAST function to find any value of A let us say 4.6 but just correspond to certain value of H $C$3
=FORECAST(F15,OFFSET($C$3,MATCH(F15,$B$3:$B$16,1)-1,0,2),OFFSET($B$3,MATCH(F15,$B$3:$B$16,1)-1,0,2))
Could you help me to find a formula to find the factor for any A and H values.
Best Regards