trying to determine a function to give me a true/false statement

[wannabe_guru]

if i have a set of projects with an expected start date - im trying to compare to see if these projects are still budgeting dollars after their start date.


i just want to pull something back - via true/false saying.


Project A - 5/1/12 Jan-12 $10 Feb-12 $10 Mar-12 $10 Apr-12 $10 May-12 $10 June-12 $10

This should say false.


Project B - 3/1/12 Jan-12 $10 Feb-12 $10 Mar-12 $10 Apr-12 $0 May-12 $0 June-12 $0

This should say true.

 

[oldchippy]

Hi wannabe_guru,


Welcome to the forum, I like your name


It's not exactly clear how your data is set out, but if you could upload a file maybe someone can help


http://chandoo.org/forums/topic/posting-a-sample-workbook

 

[wannabe_guru]

[pre]

Project 	Go Live Date	Jan-12	Feb-12	Mar-12	Apr-12	May-12	Jun-12	Jul-12	Aug-12	Sep-12	Oct-12	Nov-12	Dec-12		BUDGET PASS GO LIVE DATE
A	10/1/2012		10	10	10	10	10	10	10	10	10	10	10			FALSE
B	2/15/2012		10	10												TRUE
C	3/30/2012		10	10	10	10	10	10								FALSE
D	11/15/2012		10	10	10	10	10	10	10	10	10	10	10			TRUE
E	7/15/2012		10	10	10	10	10	10	10							TRUE

[/pre]

 

[wannabe_guru]

crap it almost came over like it is in the workbook!


i hope someone who sees this gets what i was trying to make.

 

[Hui]

Wannabe_guru


Firstly, Welcome to the Chandoo.org Forums


A quick question, using the data in Project B

It has a start date of 2/15 and data in Feb so should it be True or False?

What are your rules for this decision?

 

[wannabe_guru]

Should be true. The reason is because, there are no dollars allocated after February 2012. So true would be correct.


The goal should be - based of the projects start dates, if there are any dollars past that month it goes live, it should be false.

 

[Faseeh]

Hi wannabe_guru,


Assuming your data is present in A1:O6, this one is working:

=IF(SUMPRODUCT((C$1:N$1>$B2)*(C2:N2))>0,"FALSE","TRUE")

Regards,

Faseeh

 

[wannabe_guru]

wowza :D


that is pretty freaking cool, now lets see if i can understand it :D