Help: Need to express progressions in Excel

[SzczerbiakManiac]

I will try to explain this as best I can. I have a series of numeric progressions (all integers) that I need to be able to calculate in Excel. Here they are:

L	L/2	L*.75	L	(L-4)/3		?	??
1	+0	+0	+1	+0		+0	+0
2	+1	+1	+2	+0		+0	+0
3	+1	+2	+3	+0		+0	+1
4	+2	+3	+4	+0		+0	+2
5	+2	+3	+5	+0		+1	+3
6	+3	+4	+6	+0		+1	+4
7	+3	+5	+7	+1		+2	+4
8	+4	+6	+8	+1		+3	+5
9	+4	+6	+9	+1		+3	+6
10	+5	+7	+10	+2		+4	+7
11	+5	+8	+11	+2		+4	+8
12	+6	+9	+12	+2		+5	+8
13	+6	+9	+13	+3		+6	+9
14	+7	+10	+14	+3		+6	+10
15	+7	+11	+15	+3		+7	+11
16	+8	+12	+16	+4		+8	+12
17	+8	+12	+17	+4		+8	+12
18	+9	+13	+18	+4		+9	+13
19	+9	+14	+19	+5		+9	+14
20	+10	+15	+20	+5		+10	+15

The First column is the level of the progression. The next four columns are progressions I have figured out. The formula for each one is in the header.

It's the last two columns that I can't figure out. How would I express each of those using a formula? I know I can do an Index (Array?), but that seems so clunky.

I suspect the column marked "?" cannot be expressed by a formula because of the +2 at Level 7.

Your input is greatly appreciated.

[SzczerbiakManiac]

Okay, figured out (with help) the last column (??). Its formula is "(L-1)*.8"

Also, the irregularity in the "?" column is at Level 16. I have a feeling it should be a +7.

[wendybeth]

Uhmm, yeah....sure. Well, I"ll take your word for it, anyway.

Okay, I have to go to the stupid persons thread now......