I have the follow block of data in cells A10:G16. I need a formula to search for the value 4 in this block of cells. If 4 is found then return YES, if not then return NO.
<tbody>
</tbody>
A | B | C | D | E | F | G | |
---|---|---|---|---|---|---|---|
10 | S | M | T | W | T | F | S |
11 | 1 | ||||||
12 | 2 | X | 4 | X | X | X | 8 |
13 | 9 | X | X | X | X | X | 15 |
14 | 16 | X | X | X | X | X | 22 |
15 | 23 | X | X | X | X | X | 29 |
16 | 30 | X |
<tbody>
</tbody>
DOO