Hi,

You didn't say what the default position is if A1 is NOT blank. So I have made an assumption.

Formula: copy to clipboard
=IF(ISBLANK(A1),IF(ISERROR(B1),IF(ISERROR(C1),D1+1,C1+1),B1+1),"A1 Not blank")