Days | R1 | R2 | R3 | R4 | R5 | R6 | R7 | Completed |
3 | ||||||||
1 | ||||||||
7 |
<tbody>
</tbody>
Hi,
Im trying to figure out the formula to go in the "Completed" column in my sheet above, which should show "Yes" or "No".
The Days column can contain a number between 1 and 7.
The first row of the days column has the value 3, so I want to have the Completed column to show "Yes" if R1,R2 and R3 *all* contain any value, otherwise it should show "No".
Likewise the 2nd row in the days column has the value 1 so only R1 needs to have a value to show "Yes" in the Completed column.
again the 3rd days row has 7 so all 7 R columns need a value to show "Yes".
Thanks
John