First thing, How to attach a file for the reference??
My query:- As I move cells, is it possible automatically move the reference cell for the formula?
| Inflation Rate |
8% |
8% |
8% |
8% |
8% |
8% |
| Inflation Mutliplier |
1 |
2 |
3 |
4 |
5 |
6 |
| |
|
|
|
|
|
| Cost |
5.00 |
5.00 |
5.00 |
5.00 |
5.00 |
|
| Cost with Inflation |
5.40 |
5.83 |
6.30 |
6.80 |
7.35 |
|
In the above sheet, Cost is linked with the Inflation rate & Inflation multiplier (for different years). If I copy paste the cost from year 1 - 5 to Year 1-6, it still refers to old Inflation Multiplier.
I am looking at the solution where it automatically recalculate the "Cost with Inflation" taking care of respective Inflation multiplier years.
Would appreciate any possible support.
Thanks & regards
Mayank Jain