What formula or function would tell a cell (D7) that its value has to be a whole number either 1 or 2; or if there is a value in D6 then its value (D7) has to be zero? I would then need to the same for cell D6 where its value has to be whole number either 1 or 2; or it would be zero if no value in D7.

This is for a score card more or less where you can either get points for one factor but not the other.

Thank you!