Feb 19 2020 09:12 AM
Hello everyone. I am trying to create a column where, if any there is any non-empty cell between $B3 and $B5 then $B7 should return boolean TRUE or FALSE, keep in mind that B2 is not included in the column that i want evaluated, for example the first column ends in FALSE
A2 | A3 | A4 | A5 | A6 | A7 | |
Client 1 | dcew | FALSE | ||||
Client 2 | FALSE | |||||
Client 3 | 778 | fd | TRUE | |||
Client 4 | FALSE | |||||
Client 5 | ddd | TRUE | TRUE | |||
Client 6 | ddfs | dfas | adsf | sad | dafdsaf | TRUE |
Client 7 | FALSE |
Feb 19 2020 10:01 AM