I have column A, where row 1 starts with 1 and each subsequent row adds 1. For example:
Column A
1
2
3
4
5
...
100
In column B, row 1 starts with 3. Row 100 ends with 1.
I need a formula that will fill in column B with the appropriate value. Here's how it should look:
ColumnA ColumnB
0 3.00
1 2.98
2 2.96
3 2.94
4 2.92
5 2.90
6 2.88
7 2.86
8 2.84
9 2.82
10 2.80
...
100 1.00
Column A
1
2
3
4
5
...
100
In column B, row 1 starts with 3. Row 100 ends with 1.
I need a formula that will fill in column B with the appropriate value. Here's how it should look:
ColumnA ColumnB
0 3.00
1 2.98
2 2.96
3 2.94
4 2.92
5 2.90
6 2.88
7 2.86
8 2.84
9 2.82
10 2.80
...
100 1.00
Last edited: