Multi-Row Formula Tool

[Tim6]

Hi There, 

i am looking to build if else conditions using the multi-row formula. 

Basically I have the following data: 

1) Compounding frequency = either 2 or 12 

2) Generated Months = 1, 2, 3 

3) Daily Interest Rate = IR/31, IR/29, IR/31

I would like to write an if statement that can pick up the correct interest rate give the specific month and the compounding frequency 

would you be able to help? 

Thank you! 

[DavidP · Accepted solution]

If I understand the problem correctly, I think this is what you want.

1. Calculate the correct number of days in each month

2. Set values of EAR and EMR

3. Based on Compounding frequency, pick either EAR or EMR and divide by number of days in the month to get interest rate