Hello,
I am looking for a formula that will allow us to automatically fill in the sales of units for a given assumption.
The assumption is that we will sell 2 houses every other month. I have these as drivers of:
2 sales
Every 2 months
I need it to populate the cells automatically. I need it to be:
1/1/23 - 0 sales
2/1/23 - 2 sales
3/1/23 - 0 sales
4/1/23 - 2 sales
and so on. How can I accomplish this?
I am looking for a formula that will allow us to automatically fill in the sales of units for a given assumption.
The assumption is that we will sell 2 houses every other month. I have these as drivers of:
2 sales
Every 2 months
I need it to populate the cells automatically. I need it to be:
1/1/23 - 0 sales
2/1/23 - 2 sales
3/1/23 - 0 sales
4/1/23 - 2 sales
and so on. How can I accomplish this?