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 1 année et 6 mois.
3 sujets de 1 à 3 (sur un total de 3)
  • Auteur
    Articles
  • 13 mars 2023 à 6 h 04 min #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.
    22 mars 2023 à 15 h 33 min #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.
    2 avril 2023 à 18 h 37 min #127129
    Nidhi Puri
    Participant

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

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