Look at the fist cell that is referenced example in cel D1 we have a formula

=(A1+C1)/100
change it to this

=(If A1="","",(A1+C1)/100

to explain what it is doing

If A1 = nothing , then nothing , otherwise perform the formula