G
Guest
I have a monthly budget which I have been using for a few years. And for
those years I’ve tried to write a formula so that a row does not show the
last number all the way down the row. For example I allow myself $100 a day
for frolic and fun. So I have a column “spent daily†(I). And a row to
“total spent†(J). i.e. if I spent $20 on 1st $60 on the 2nd and $220 on
the 3rd “total spent†(=J2-I3) would show -$100 all the way down through the
31st. I also have a “can spend†column. If I do what I’m doing now for 3
days I don’t spend anything tomorrow I can send $400, with the same problem.
Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent. I used to be able to do this sort of
thing, but now I spend a lot of time looking for the pants I’m wearing.
those years I’ve tried to write a formula so that a row does not show the
last number all the way down the row. For example I allow myself $100 a day
for frolic and fun. So I have a column “spent daily†(I). And a row to
“total spent†(J). i.e. if I spent $20 on 1st $60 on the 2nd and $220 on
the 3rd “total spent†(=J2-I3) would show -$100 all the way down through the
31st. I also have a “can spend†column. If I do what I’m doing now for 3
days I don’t spend anything tomorrow I can send $400, with the same problem.
Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent. I used to be able to do this sort of
thing, but now I spend a lot of time looking for the pants I’m wearing.