Hello
I need help with a formula that isn't working and I am getting confused. I need to phase contract renewals and have tried to combine 3 if formuals to allocate the value over each specific contract period (in days) [contract period shown in BT:BU]. I need a formula to complete the examples on BD6:BS7 on the attached but cannot make it work and am struggling where contracts start/ end mid month- please help!
Thank you
This is one of those questions where we (I at least) would need to see some expected results as well as the base data, without knowing what the expected result is, I have no way of figuring out exactly what you want...
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Any luck guys?
Still struggling with this one.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks