Multi-Row Formula Tool

Question

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!

Altreyx Question.xlsx

DavidP · Accepted Answer

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