IF Condition for calculating Coupon dates

[Shahmeer]

I have 2 types of Bonds 3 years & 5 Years Maturity with following coupons:

1st Coupon 2nd Coupon 3rd Coupon 4th Coupon 5th Coupon 6th Coupon 7th Coupon 8th Coupon 9th Coupon 10th Coupon

I need to establish one combine IF condition in these 10 Coupons in following manner:

IF Bond is for 3 years then total semi-annual coupons shall be 3*2=6
IF Bond is for 5 years then total semi-annual coupons shall be 5*2=10

The formula should start providing coupon dates for both bonds but stop at or give coupon dates for 3 years bonds till 6th coupon but in case of 5 years bond bond coupons may end in 10th Coupon.

I have following formula in place:

=IF(AND(S3>$Y$1,Y3="Outstanding",T3="Coupon Bond"),IF(OR(V3="3-Years",V3="5-Years"),EDATE(H3,6))," ")

The problem is it works till 10th coupon for 3 year and 5 year. It must show blank in 7th coupon for 3 years bond.

Please help me. Many Regards and tribute to Forum Genius Gurus.

[AliGW]

Are you still using Excel 2016?

There are instructions at the top of the page explaining how to attach your sample workbook (yellow banner: HOW TO ATTACH YOUR SAMPLE WORKBOOK). Screenshots are of little practical use as we cannot manipulate them.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, worked examples where required, relevant cells highlighted and a few explanatory notes.

[Shahmeer]

Anybody Please help me in this issue. Thanks

[JohnTopley]

Try

Please Login or Register  to view this content.

[Shahmeer]

Thanks for Support. Great.