Not sure this'll help, but worth a try ...

In my experience, B4=0 and B4=empty aren't the same thing and thus
wouldn't fit under Condition #1.

Try adding [ B4="" ], without the [], to the OR formula in Condition
#1 ... I didn't test this, but I'm guessing that it'll work

br//ray