TahaU_*81964 image

  • How to create a loop formula

    Hi everyone, I am stuck on a formula. I have demands for 2021 and I need to calculate the demand forecast until 2030 by using the formula below Demand 2022= Demand 2021*Growth rate 2022 Demand 2023= …
  • Re: How to create a loop formula

    Hi @TimothyThomas, Thank you for your reply. It is a good idea. I have already tried something similar to your answer. My problem is that I need to calculate the monthly demand forecast and when I us…
  • Re: How to create a loop formula

    Hi @ankit_cheeni, Thank you for your great answers each time I ask a question! I was able to do it with the OFFSET function. IF NOT 'SYS00 Time Settings bu Month'.Current Year? THEN OFFSET(…
Avatar