Can do this without Macros?

rs008f · Mar 12th, 2002, 11:42 AM

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 shited 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.

Jack in the UK · Mar 12th, 2002, 12:08 PM

Please refer to this post as this has been posted twice.

Cheers

http://www.mrexcel.com/board/viewtop...1947&forum=2&3

Mar 12th, 2002, 12:08 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Please refer to this post as this has been posted twice. Cheers http://www.mrexcel.com/board/viewtop...1947&forum=2&3 __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 11:42 AM	#1
rs008f New Member Join Date: Mar 2002 Location: Rochetser, NY Posts: 7	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 shited 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.