Hi
I ‘borrowed’ the attached formula for my household inventory to try and get a new for old price calculated to take account of inflation. As this is obviously on the rise I wanted to change the formula to account for the increase in the inflation rate.
As I don’t understand formulas I was hoping some kind soul out there could briefly explain the formula and also how to alter it to increase the inflation calculation?
Hope that make sense and thanks.
Attachments:
You must be
logged in to view attached files.
Well I can tell you that the POW(X; Y)
function raises X
to the power of Y
. The DAYS()
function returns the number of days between the Purchase Date and the current date/time.
But I don’t know how this relates to inflation as I’m not a financial calculations expert.
Thanks Brendan, wonder if anyone else can chip in? Much appreciated if you can, or suggest an alternative?
Cheers…