Formula Help

Accueil – Le CFO masqué Forums Excel Formula Help

  • Ce sujet contient 2 réponses, 2 participants et a été mis à jour pour la dernière fois par Nidhi Puri, le il y a 10 mois et 4 semaines.
3 sujets de 1 à 3 (sur un total de 3)
  • Auteur
    Articles
  • #126569
    Nidhi Puri
    Participant

    Hi,
    I am trying to create a rent roll that would increase by a growth factor every 12 months, but this growth would depend on the start date of the lease so it could be same or different for different apartment units.
    I have attached a file and shown the results I need in yellow with manual calculation. I would like to understand what formula would work in this situation and it works when the formula is applied horizontally and vertically. Hope I am able to explain what I am trying to do.

    Attachments:
    You must be logged in to view attached files.
    #126849
    Sylvie Giroux
    Participant

    Hello, I tried to help you find a solution to your formula problem. The solution that I propose in the attached file may not be the most optimal, but I did not manage to do it differently. Hope it suits you.

    Attachments:
    You must be logged in to view attached files.
    #127129
    Nidhi Puri
    Participant

    Thank you, Sylvie. C’est un problem un petit peu complique 🙂

3 sujets de 1 à 3 (sur un total de 3)
  • Vous devez être connecté pour répondre à ce sujet.