Formula Help

Accueil – Le CFO masqué › Forums › Excel › Formula Help

  • Ce sujet contient 2 réponse, 2 participant et a été mis à jour pour la dernière fois par Nidhi Puri, le il y a 2 années et 2 mois.
Affichage de 1 message (sur 3 au total)
  • Auteur
    Messages
  • 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
    Messages
Affichage de 1 message (sur 3 au total)
  • Vous devez être connecté pour répondre à ce sujet.