Can’t understand formula

Viewing 2 reply threads
  • Author
    Posts
  • September 8, 2022 at 9:33 AM #47937

    tonyt
    Participant

    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.
    September 9, 2022 at 10:44 PM #47950

    Brendan
    Keymaster

    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.

    September 10, 2022 at 1:11 AM #47958

    tonyt
    Participant

    Thanks Brendan, wonder if anyone else can chip in? Much appreciated if you can, or suggest an alternative?
    Cheers…

Viewing 2 reply threads

You must be logged in to reply to this topic.