hi
I just joined the forum and very happy that i'll be able to post my questions
I've spent more than two weeks on this puzzle without success, so i really hope you guys can help.
The question:
I would like to distribute values in cells depending on the input value (excel file attached).
This file is a test and basically i've been entering the data manualy. The format is flexible, so it can be reorganisaed.
looking forward for you comments :-)
Last edited by msal; 03-02-2009 at 07:59 PM.
Hi, and welcome to the forum.
It would be possible to modify the formula in say F7 (Phase 3) of the Test sheet to reflect the number of years, but it's not obvious why the start year is 2011. What determines the start year?
If this was held as a variable in the Input tables then that would provide one solution.
Rgds
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
thanks !
Basically the 'pink coloured' cells from TEST worksheet are connected with another worksheet and will always be a number without decimals. This is the input value (Phase 1). All the other phases should be linked with Phase 1 value and distributed through years depending on the value entered in the INPUT field.
Does it make sense?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks