Stop Formula After Condition is Met

So the problem I'm having is I'm trying to make a formula that is adaptive to the rest of the formula but I don't know how to stop it after the conditions are met. I've attached an example and the highlighted row is the one I'd like fixed. The conditions are if the other cells are blank then that one should be blank too. But if it is the final year in the model then it should equal a certain value. The problem I'm having is I don't know how to stop it after the conditions are met. Any help is appreciated. Thanks