Below is an example of my spreadsheet.
Time 0 months (time required for profits to be earned)
Month 1 2 3 4 5 6 7 8 9 10 11 12
Profits($)10 20 30 40 50 60 70 80 90 100 110 120 (Profit #s are made-up, what if the numbers have no pattern and random)
My situation is as follows:
The profits depends of Time. If it is 5 months, then all the profits will be ****ed 5 months later; $10 would be appear under Month 6 and so on. Changing the # of Months will automatically shift the profits back and forth. What formula or tricks should I use to attain this. I tried using the IF function but it's too tedious and wasn't successful as it only allows 7 levels whereas there are 12 months(13 possibilities) in a year. Any advise would be great.
Time 0 months (time required for profits to be earned)
Month 1 2 3 4 5 6 7 8 9 10 11 12
Profits($)10 20 30 40 50 60 70 80 90 100 110 120 (Profit #s are made-up, what if the numbers have no pattern and random)
My situation is as follows:
The profits depends of Time. If it is 5 months, then all the profits will be ****ed 5 months later; $10 would be appear under Month 6 and so on. Changing the # of Months will automatically shift the profits back and forth. What formula or tricks should I use to attain this. I tried using the IF function but it's too tedious and wasn't successful as it only allows 7 levels whereas there are 12 months(13 possibilities) in a year. Any advise would be great.