IF Statement

Hi,

I need an if statement that says

If on any row in ColumnE the date = today, then check ColumnC and ColumnD, if both are not equal to zero, return "Check", if they are, return blank

Thanks
Seamus
Seamus2626Asked:
Who is Participating?
 
jppintoConnect With a Mentor Commented:
=IF(MATCH(TODAY(),E:E,0),IF(AND(INDEX(C:C,MATCH(TODAY(),E:E,0))=0,INDEX(D:D,MATCH(TODAY(),E:E,0))=0),"","Check"))
0
 
Seamus2626Author Commented:
Thanks Jpinto!

Cheers,
Seamus
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.