Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Need help with a formula (Excel 2003)

    Morning!

    I am hoping that someone can help me with a formula that I am using to put together cumulative forecast numbers. The problem that I am running into with my current formula (graph data tab, cell b8) is that because this is a "Holiday" I need for it to pull the cumulative forecast number to the prior date. I have a defined range for holidays, but seem to be getting an error when I add an IF statement to look at the date in cell A8, and if it is a holiday, from my list of defined holidays, then take the number from the cell above. I hope that this makes sense, and appreciate any assistance you can provide/suggest.

    =IF(A8=" ","",(B7+LOOKUP(EOMONTH(BOM,0)+1,FDate,Frcst_JFund ed)/FDIM))

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Need help with a formula (Excel 2003)

    Does this do what you want?

    =IF(A8=" ","",IF(ISNA(MATCH(A8,Holidays,0)),(B7+LOOKUP(LAAT STE.DAG(BOM,0)+1,FDate,Frcst_JFunded)/FDIM),B7))

  3. #3
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Mechanicsville, Virginia, USA
    Posts
    130
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Need help with a formula (Excel 2003)

    It worked like a charm! Thanks again Hans!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •