Average value formula

[coolwater]

Hi,
I have a set of data,

Jan-Jun-- I have actual numbers, which I can do a vlookup from another sheet, but for July, I will need to get average number from previous two month's actual plus a price increase rate for July. for August, it will be July number plus a price increase rate for August.

for example:
Jan- 24 5
Feb-24 10
Mar-24 30
Apr-24 40
May-24 50
Jun-24 60
Jul-24 =average(May24,Jun24)*(100%+1%)
Aug-24 =Jul24*(100%+2%)
Sep-24
Oct-24
Nov-24
Dec-24

I am looking for to automate this report, so we don't have to update every month, all we need to do it get the actual number then the budget month should all flown in.
hope this makes sense. any help would be appreciate it.
thank you.

[6StringJazzer]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #2 about thread duplication.

I am closing this thread, but you may continue here in the original thread

Thread closed.