I need to build a Monte Carlo simulation model that does 10 iterations on the interest rate tree. I need to identify the interest rate given a sequence of moving up and down the interest rate tree. I managed to create an IF statement until i=2, however it gets tricky on i=3 onwards.
Any suggestions? I was told to use the INDEX() function, but I fail to see how I can use it as a condition.
EDIT: This is what I have on node 2 -> =IF(U4="up",IF(X4="up",D10,D11),IF(X4="up",D11,D12))