• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. Y

    Continuity - Selecting Value based on range of dates (that change)

    One down. I can populate end of month. Via this formula. Now need to crack middle of month. =IF(MONTH(G3)=MONTH(H3),0,$E$26)
  2. Y

    Continuity - Selecting Value based on range of dates (that change)

    It is indeed. Im trying this route: =IF(MATCH((EOMONTH(G3,-1)+15),G3),$E$25,IF(MATCH((EOMONTH(G3,0)),G3),$E$25,"NA")) But not really working out.
  3. Y

    Continuity - Selecting Value based on range of dates (that change)

    Sure. It is attached. The date calculation needs to be relative so that as we update the interval it can move w/it. In sample spreadsheet, the dollar amounts are hard coded. Thats where the formulas should ideally go.
  4. Y

    Continuity - Selecting Value based on range of dates (that change)

    Here is the use case. A have column headings that are dated friday of each week. Each friday, I updated the first column heading, and the rest ones update themselves into the forecast. I'm doing a cashflow forecast. Based on the week/month, I apply certain costs to that column. I pull data...
  5. Y

    Super Complex Logic Formula (at least to me)

    Hui, I got there w/3 sets of helper rows. Thanks again. Not as pretty as I would have liked, but gets the job done.
  6. Y

    Super Complex Logic Formula (at least to me)

    Never-mind on my last post, I added an IF statement at the beginning to suppress 0's. making progress.
  7. Y

    Super Complex Logic Formula (at least to me)

    One thing to note Hui, Helper rows throw off the NPV formula, b/c they insert 0 value periods when instead the NPV being calculated from the helper rows should start the first period where there are values (not 0 period). Is there a way to suppress 0 value cells for the NPV calculation of...
  8. Y

    Super Complex Logic Formula (at least to me)

    Hui, You are 1/2 way there, but by using E39, you are only getting the NPV vs rNPV (row 41). The problem I am having is calculating the rNPV on future phases as if is that future phase has already occurred (i.e. I am already at Phase III or NDA phase). When I go forward in time, my risk...
  9. Y

    Super Complex Logic Formula (at least to me)

    Anyone have any thoughts?
  10. Y

    Can an IF function be based on the color of a cell?

    I dont think so. You can do the opposite, make a cell a color based on the values it contains (Conditional Formatting), but I dont think you can make the IF statement use the color (at least not w/out some VBA).
  11. Y

    Super Complex Logic Formula (at least to me)

    Try this. https://www.dropbox.com/sh/s3b2lf2dyiuvzte/9NgJLwJUkw See as you cycle through the different sample cases I have built the phase duration can change, and hence so does the NPV, and the subsequent NPV's I want to model. Yamil
  12. Y

    Super Complex Logic Formula (at least to me)

    I have a worksheet/ table (P&L) that is populated based on the values from an Input worksheet. The P&L is phase based (where phases only calculate costs until you reach revenues), so as the project moves from phase to the next (a phase can take multiple years/columns) the values and value of...
Back
Top