When you say NULL, I imagine that you are asking if the formula can be put into the empty cells in column D.
If there is a way to do that it would involve VBA of which I know too little to help, however you may want to ask a moderator to move this thread to that forum and see if one of the contributors over there can help.