Hi,
I have 3 columns of data.
Column A is the "Date" in 1/12/1984 format
Column B is the "Account Balance" that corresponds to each Date in Column A
Column C is an If formula that returns the Account Balance in Column B if the Date in Column A is month end. - This column just gives me the month end balances.
I would like to add a Column D that will calculate the monthly change in account balances when there is data in Column C. My problem here is that I cannot just use = (B-A)/A because there are cells interspersed in Column C that do not contain data. I could manually look to see if there is data in column C and just input the formula for each cell, but there are many months of data, so it would be very tedius. Is there a way to accomplish this with a formula?
Thanks!
I have 3 columns of data.
Column A is the "Date" in 1/12/1984 format
Column B is the "Account Balance" that corresponds to each Date in Column A
Column C is an If formula that returns the Account Balance in Column B if the Date in Column A is month end. - This column just gives me the month end balances.
I would like to add a Column D that will calculate the monthly change in account balances when there is data in Column C. My problem here is that I cannot just use = (B-A)/A because there are cells interspersed in Column C that do not contain data. I could manually look to see if there is data in column C and just input the formula for each cell, but there are many months of data, so it would be very tedius. Is there a way to accomplish this with a formula?
Thanks!