I'm trying to get a multiple nested if() to work with multiples of month correctly. I think edate should do the trick but I'm banging my head against the wall trying to only get my last if() true if a x month multiple of the reference date:
+if(and(this period's date (s7) is greater than a reference date (Assumptions_General!$I$30), & this month is a multiple of three of the reference date (ie 3 month increments)), (Assumptions_General!$j$30, 0)
I'm buying my first widget on x date. I'll buy y more widgets every three months (if seller has any left but I can handle that part). I'm just trying to show in a row how many widgets I'm buying each month; either y or 0 depending on if the current month is three months after the first month.
Where I am so far...
=+IF(S7=Assumptions_General!$I$28,Assumptions_General!$J$28,IF(S7=Assumptions_General!$I$29,Assumptions_General!$J$29,IF(S7=Assumptions_General!$I$30,Assumptions_General!$J$30,IF(AND(S7>Assumptions_General!$I$30,EDATE('Cash Flows'!S7,-Assumptions_General!$I$31+1)>Assumptions_General!$I$30),Assumptions_General!$J$30,0))))
See attached. I have my nested if() working (see s1 on 'cash flows') but I cannot get my final condition...only returning the five lots every three months (or x months as controlled on 'assumptions'). BTW: Is there a cleaner way to do the nested if() based on the Lot Takedown Schedule on 'Assumptions'?
Bookmarks