Cannot figure out....

[buteaur]

How can I make an if statement pick up on a first data point and then any other data points that have a number?

Example:

=IF(AND(C2>0,D2>0,E2>0,F2>0),1,0)

This obviously doesn't work because, let's say, d2 is zero but f2 has a value, the answer will come back "false".

How do I get it to say if there is a value in c2 (that's my constant) and then there are any values in the following cells, return "true"?

help would be appreciated!!

 

[jproffer]

Try this:

=IF(AND(C2>0,OR(D2>0,E2>0,F2>0)),1,0)

 

[buteaur]

I'm an idiot..... ha!

Thank you!!!!!!!!!!!!!!!!!!!!!!!

 

[jproffer]

Naaaaaaaaa ...sometimes it takes an outside look (especially after hours of working on the same workbook) to see something obvious. Been there.

Glad it worked.