Need Help with New Business Model

[PKR]

Need to get simple formulae where in the first centre is operational for 12 months and 2nd for 11 months and so on. A file is attached. Thank you for your help

 

[jayalaxmi]

Need to get simple formulae where in the first centre is operational for 12 months and 2nd for 11 months and so on. A file is attached. Thank you for your help

can u more precise on what u need??

Regards,
Jaya

 

[Luke M]

Welcome to the forum, PKR.

Please see attached, which shows how to build the data table and results.

 

[jayalaxmi]

hello Mr.luke,

Pls have a look on formula question thread??

Regards,
Jaya

 

[PKR]

Welcome to the forum, PKR.

Please see attached, which shows how to build the data table and results.

thanks for the calculations. I have bigger base of 84 months X 5 sets. Is it possible to have one cell formula for each months for each set. Thanks.

 

[Luke M]

No. Each month needs to be kept track of individually. Thankfully, XL doesn't charge us for using more rows/columns, so you have plenty of space.
The setup I gave you can easily be extended/shrunk to handle different size arrays.