Question
Inflation calculation Excel formula help: Inflation is 2% per year, broken down on a monthly basis in each cell. It should be something that I
Inflation calculation Excel formula help:
Inflation is 2% per year, broken down on a monthly basis in each cell. It should be something that I can just drag to copy to the rest of the cells, so that's what I'm trying to figure out. PLEASE PROVIDE CELL REFERENCES FOR WHAT TO CLICK AND FORMAT OF FORMULA I NEED TO USE. Screen shot of everything is ok.
The below image is what I need to recreate (ONLY THE INFLATION CALCULATION PART--It's my multiplier for the rest of the spreadsheet), which is what I am asking you for help to do:
Row A has month references; Colum C Row 4 is the annual inflation rate. Monthly inflation Row 4 Column D and onward.
I am asking for the fill-formula to do be able to expand this to the right, all the way to month 72. What do I do?
1 1/1/2022 2022 1 2 2/1/2022 2022 1.001666667 3 3/1/2022 2022 1.003336111 4 4/1/2022 2022 1.005008338 5 5/1/2022 2022 1.006683352 6 6/1/2022 2022 1.008361157 7 7/1/2022 2022 1.010041759 8 8/1/2022 2022 1.011725162 9 9/1/2022 2022 1.013411371 10 10/1/2022 2022 1.01510039 Inflation 296
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started