This is probably a very basic question, sorry. I am making a general ledger.
Here is what I want to do. In Cell H5, =SUM(G5+H4). If I autofill all the way down it brings the last balance with it. I want it to put a 0 or - in if G5 is empty. So if G5 is empty enter 0 or add G5 to H4.
I hope this makes sense.
Thanks,
Here is what I want to do. In Cell H5, =SUM(G5+H4). If I autofill all the way down it brings the last balance with it. I want it to put a 0 or - in if G5 is empty. So if G5 is empty enter 0 or add G5 to H4.
I hope this makes sense.
Thanks,