From the calculation below, when the two (2) dates in cell C19 and D19 are subtracted, it returns a value of 62 days, which is in the range of cell B8 (70 - 61 days). Now, the problem is getting the amount in cell F19 ($50,000.00) to automatically sort itself into the array of cells in column C (i.e. C5 - C14).
Not sure what you want here. Is the result meant to appear in cell F19 or cell C8?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
what I want is that any amount in cell F19 appears on any of the cell from C5 to C14 based on the value in cell E19.Originally Posted by AliGW
In the attached sheet, the amount in F19 appeared in C8 because E19 is 62. If for example E19 is 13, then the $50,000.00 would be in C13. And if E19 is 93, then the $50,000.00 would be in C5.
All these, without having to tamper with column C.
Got it?
Last edited by bolajidopemu; 05-31-2016 at 10:57 AM.
There would have to be a formula in column C, though.
That's why I need help.
But you said that column C must not be tampered with. So are you saying that it's OK to have a formula in column C? If not, I don't see how it can be done without VBA, perhaps.
Enter this in C5 and fill down. I don't understand "not tampering with column C".
Formula:
Please Login or Register to view this content.
Last edited by newdoverman; 05-31-2016 at 11:36 AM.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Wow.....it worked!!!!! Thanks guys......nice work.Enter this in C5 and fill down. I don't understand "not tampering with column C".
Formula:Please Login or Register to view this content.
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks