This would be much simpler

=IF(COUNTIF(B3:G3,"OFF"),"OFF","NOT OFF")