Hide following numbers
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. |
All times are GMT +1. The time now is 07:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com