![]() |
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 ? ?? 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. |
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. |
Uhmm, yeah....sure. Well, I"ll take your word for it, anyway.
Okay, I have to go to the stupid persons thread now......:rolleyes: |
All times are GMT -7. The time now is 02:38 PM. |
Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.