True of false if any column is non-blank

Iron Contributor

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

 

 

 A2A3A4A5A6A7
Client 1dcew    FALSE
Client 2     FALSE
Client 3 778fd  TRUE
Client 4     FALSE
Client 5  dddTRUE TRUE
Client 6ddfsdfasadsfsaddafdsafTRUE
Client 7     FALSE
1 Reply

@Ocasio27 

 

This seems to work:

=IF(COUNTA(E7:H7) >= COUNTBLANK(E7:H7),TRUE,FALSE)