Check row for cell greater than 0

You can use this formula in F3:

=IF(COUNTIF(B3:E3,"#N/A")=4,"#N/A",((COUNTIF(B3:E3,">0"))>=(4-COUNTIF(B3:E3,"#N/A")))*1)

then copy down.

Hope this helps.

Pete