Formula Help

This topic has 2 replies, 2 voices, and was last updated 2 years ago by Nidhi Puri.

Viewing 3 posts - 1 through 3 (of 3 total)

Author

Posts
13 March 2023 at 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 March 2023 at 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 April 2023 at 18 h 37 min #127129

Nidhi Puri
Participant

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

Posts

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.