I couldn't understand what your are trying but you can write the if as aformula in the column for differencesContinuing with your first example in k3 you can write =if(j3="",0,J3-A1)Then you try again with the conditional formant