Thanks for the reply JF, but would this not revert back in the following year if the value to add on this occasion was only 3%, i.e.
Description Part No. Qty Cost Total
Bearing B2343 3 Price+ref Qty+cost
If the reference cell on year one was set to 4%...
I am a novice user of Excel and I am getting a little stuck with trying to update a list of prices (say a parts list) to include annual percentage increases.
For instance this year may require the prices updating by 4% and next year by 3%.
I was looking to put a value to increase by on the...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.