SOLVED

Formula assist

Brass Contributor

Dears,

Could you please assist with a formula to apply for a list of contracts that include start date & end date with increase % per year such as the attached sample.

 

Thanks in advance

4 Replies

@Hussein_Mohamed 

Option 1: in all versions of Excel, enter the formula

 

=IF(OR(AC$1<$K2,AC$1>$L2),"",$P2*(1+$O2)^DATEDIF($K2,AC$1,"y"))

 

in AC2, then fill to the right.

 

Option 2: for Excel in Microsoft 365 or Office 2021 only, enter the formula

 

=IF((AC$1:FG$1<$K2)+(AC$1:FG$1>$L2),"",$P2*(1+$O2)^DATEDIF($K2,AC$1:FG$1,"y"))

 

in AC2. It will automatically spill to the right.

@Hans Vogelaar 

Thank you very much for your usual support, 

Could you provide me with a formula to sum the amount per year

best response confirmed by Hussein_Mohamed (Brass Contributor)
Solution

@Hussein_Mohamed 

See the attached the workbook.

Many Thanks Mr. Hans
1 best response

Accepted Solutions
best response confirmed by Hussein_Mohamed (Brass Contributor)
Solution

@Hussein_Mohamed 

See the attached the workbook.

View solution in original post