Hi, trying to figure out how populate one cell if range of other cells contain certain text

DJNelson

Want to enter text in the Late column row 71 if in the Status column rows 72-84 contain the text "Late" …. Thoughts

Thank you in advance

Dave

Brian Wilson DC

@DJNelson Hey, Dave! You will want to use this formula:

=IF(CONTAINS("Late", Status72:Status84), "This Project Is Late", "")

This will return the message "This Project Is Late" and place it in row 71 if any of the Status columns from rows 72 thru 84 are marked as Late.

I hope this helps!

-Brian

Brian Wilson DC

@DJNelson Hey, Dave! You will want to use this formula:

=IF(CONTAINS("Late", Status72:Status84), "This Project Is Late", "")

This will return the message "This Project Is Late" and place it in row 71 if any of the Status columns from rows 72 thru 84 are marked as Late.

I hope this helps!

-Brian

DJNelson

That is perfect….thank you so much