Lounge of Tomorrow

€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides.  


Go Back   Lounge of Tomorrow > A.S.C.O.T > Egg Head
Swank Swag
FAQ Members List Calendar Today's Posts Clear Unread

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old 02-18-2005, 02:29 PM   #1
SzczerbiakManiac
"ZER-bee-ak"
 
SzczerbiakManiac's Avatar
 
Join Date: Jan 2005
Posts: 4,409
SzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of coolSzczerbiakManiac is the epitome of cool
Question Help: Need to express progressions in Excel

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:
Code:
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 is offline   Submit to Quotes Reply With Quote
 



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT -7. The time now is 10:24 AM.


Lunarpages.com Web Hosting

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.