Trying to write a simple equation in excel to display subtraction for a money journal. Currently i'm using =COLUMN-ROW (=G9-C10) to produce a value. However, when I extend the series to fill the G9 column and there is a 0 entry or left blank... G9 fills the balance.

What I would like to do is fill the column with the series but either display a blank value or 0 until the corresponding row is filled then display the negative number.

Sure this is fairly basic, but I have absolutely no excel skills...