Share via

Formula

Anonymous
2020-01-29T15:04:58+00:00

Hello, 

I'm have a problem with this formula.  

Cost of living has been estimated at going up by 3.93% over the next 6 months. We would like to forecast what the expenditure will be over that period. In cell Z2 enter the value 3.93%. In Z5 enter a formula to calculate the forecast expenditure. To do this you will need to calculate the increase in expenditure (current total expenditure multiplied by the percentage increase) and add it to the current total expenditure. Copy the formula down the column. (Make sure that all the calculations are using the value in Z2!).

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2020-01-29T17:08:14+00:00

    Hello stacy

    I am V. Arya, Independent Advisor, to work with you on this issue. I am not sure 3.93% is monthly or yearly or for 6 months. I will assume it is for 6 months. Hence monthy increase would be 3.93%/6

    If your current expenditure is in Z1, then use following formula in Z5. This you can drag down

    =$Z$1+$Z$1*$Z$2*ROW(1:1)/6

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments