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.

One way:

J2: =IF(I2="","",I2)
J3: =IF(I3="","",J2-I3)

Copy J3 down to J31


In article ,
miltdp wrote:

Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent.

Thanks JE, as much as I've struggled with that it looks too simple but it
usually is. I'm sure this will do the job


"JE McGimpsey" wrote:

One way:

J2: =IF(I2="","",I2)
J3: =IF(I3="","",J2-I3)

Copy J3 down to J31


In article ,
miltdp wrote:

Is there a formula or way to keep the rest of the column (j4:J31) blank until
there is some activity in the spent.