if column A is missing or 0, Column B value will replace as 0

Book1.xlsx

What I need is, if “Score from Clients” equals to 0 or Missing, “Score from Internal customer” will also return into 0.

And if “Score from Internal customer” is 0 or Missing, “Score from Clients” also return to 0 as well.

I do not want to use row filter as I still need to keep all the information from other columns.

My ideal result

I tried to used “Rule engine”. But it cannot allow me to replace the other column’s value.

Hope someone can help me on this. Thank you so much.