I have a monthly budget which I have been using for a few years. And for
those years Ive 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 Im doing now for 3
days I dont 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 Im wearing.