Hello,
Please see the attached spreadsheet.
I would like the values in C2, C5, and C12 to evaluate the values in C3-4, C6-11, and C13-16 respectively.
For example C2 should evaluate C3 & C4:
If allvalues = 'Complete' then the value in C2 should be 'Complete'.
If any of the values = 'In Progress' then the value in C2 should be 'In Progress'
If all of the values = 'Not Started' then the value in C2 should be 'Not Started'.
I don't know what formula to use (if there is one).
Thank you.
Bookmarks