C
Chris Alexander
I'm not well enough versed in spreadsheet use to calculate some
intermediate values I need. I would be greatful for anyone who can offer
a formula or suggestion.
I have 1 guidline column, numbered 1-30. Then 2 other columns, A & B are
beside it. The values in A & B change as they go from 1-30, they change
at different rates. I have some intermediary values at given points but
need to calculate what the values in between would be, based on the
fixed values at 1, 4, 8, 15 and 30. Below, I have shown the layout as
best I can without including an attachment. Thanks.
(e-mail address removed)
1 1 1
2 2.5 3
3
4 6 7
5
6
7
8 11 15
9
10
11
12
13
14
15 27 37
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 65 95
intermediate values I need. I would be greatful for anyone who can offer
a formula or suggestion.
I have 1 guidline column, numbered 1-30. Then 2 other columns, A & B are
beside it. The values in A & B change as they go from 1-30, they change
at different rates. I have some intermediary values at given points but
need to calculate what the values in between would be, based on the
fixed values at 1, 4, 8, 15 and 30. Below, I have shown the layout as
best I can without including an attachment. Thanks.
(e-mail address removed)
1 1 1
2 2.5 3
3
4 6 7
5
6
7
8 11 15
9
10
11
12
13
14
15 27 37
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30 65 95