+ Reply to Thread
Results 1 to 6 of 6

Multiple IF AND Forecasting help?

  1. #1
    Registered User
    Join Date
    06-20-2019
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    3

    Post Multiple IF AND Forecasting help?

    I am trying to show the revenue forecasting for projects over a number of months in the attached sheet.

    In cell L3 i have the following:
    =IFERROR(IF(AND(L$1>=EOMONTH($G3,-1)+1,L$1<=EOMONTH($H3,0)),$I3,""),0)

    this is to return data for the following queries:
    * If there is an error in the result, return zero
    * If the month in L1 is between the dates of G3 & H3, return the number in I3, if not, return nothing

    This works just fine, however i would like to add in extra conditions:
    * If F3 shows "Y", and the month in L3 is either the first or second month in the series between G3 & H3, return the number in J3
    * If F3 shows "Y", and the month is between the dates G3 & H3, but neither the first nor the second month in the series, return the number in K3


    I'm at a loss for how to combine all the IFS.
    Any ideas?
    thanks EE
    Attached Files Attached Files
    Last edited by eeJames_Fisher; 08-12-2020 at 01:12 PM.

  2. #2
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Multiple IF AND Forecasting help?

    =iferror(if(and(l$1>=eomonth($g3,-1)+1,l$1<=eomonth($h3,0)),if(or(month(l$1)=month($g3),month(l$1)=month($g3)+3),$j3,$k3),""),0)
    If this solves your issue, Mark thread as Solved & Add Reputation.

    Thanks!

  3. #3
    Registered User
    Join Date
    06-20-2019
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple IF AND Forecasting help?

    AMAZING! Thanks!

  4. #4
    Registered User
    Join Date
    06-20-2019
    Location
    Bristol
    MS-Off Ver
    2016
    Posts
    3

    Re: Multiple IF AND Forecasting help?

    Oopf, thought it was solved but it only seems to work for the one line, other lines aren't quite right.
    Is it too many IFS?
    Not sure how many conditions you can actually give in one formula... Attached the updated sheet to original post to show the issue now.

  5. #5
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Multiple IF AND Forecasting help?

    Not too many - I noticed your other cells would have errors
    I do not see an attachment
    Last edited by CRIMEDOG; 08-12-2020 at 01:38 PM.

  6. #6
    Valued Forum Contributor
    Join Date
    02-04-2009
    Location
    Texas
    MS-Off Ver
    Excel 2016
    Posts
    665

    Re: Multiple IF AND Forecasting help?

    Here is what I did
    Edit - Disregard Cell L3
    Attached Files Attached Files
    Last edited by CRIMEDOG; 08-13-2020 at 10:07 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Forecasting using multiple tables and columns
    By Cobra17 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-07-2020, 02:08 PM
  2. [SOLVED] forecasting with multiple variables/criteria
    By adsako in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-29-2020, 03:57 AM
  3. [SOLVED] Forecasting
    By dianaschar in forum Excel General
    Replies: 4
    Last Post: 10-21-2013, 10:26 AM
  4. Forecasting
    By praetorianprefect in forum Excel General
    Replies: 3
    Last Post: 08-06-2011, 12:41 AM
  5. help with forecasting
    By superspurs in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-18-2009, 05:45 AM
  6. Forecasting
    By KrunoG in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-01-2006, 04:45 PM
  7. Forecasting
    By BlockNinja in forum Excel General
    Replies: 2
    Last Post: 12-13-2005, 02:15 AM

Tags for this Thread

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1