Hello,
We would like to input the month/year a project is expected to start and have a rate returned escalation if warranted.
Example: In cell D1 estimator would input the month and year a project is scheduled to start, March, 2021 and the formula in cell F1 would calculate/populate a rate of 2%. The bid worksheets in this workbook look to 'Sheet1'!$F$1 for the escalation rate.
Thank you,
We would like to input the month/year a project is expected to start and have a rate returned escalation if warranted.
Example: In cell D1 estimator would input the month and year a project is scheduled to start, March, 2021 and the formula in cell F1 would calculate/populate a rate of 2%. The bid worksheets in this workbook look to 'Sheet1'!$F$1 for the escalation rate.
- Today's date plus 0-3 months, rate of 0%
- Today's date plus 3-6 months, rate of 2%
- Today's date plus 6-12 months, rate of 3.5%
Thank you,