![]() |
€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. |
![]() |
#1 |
"ZER-bee-ak"
Join Date: Jan 2005
Posts: 4,409
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
![]() 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 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. |
![]() |
Submit to Quotes
![]() |