Need Formula for number change based on status

I am trying to write a formula for my ‘Quantity Live’ column that says “If the subitem’s ‘Pub Status’ is not LIVE, put 0. If the subitem’s ‘Pub Status’ is LIVE, put the value from the ‘Quantity Using’ column.

Any help would be appreciated.

Thank you,

Linda