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
Bookmarks