Forum Discussion

EddyW's avatar
EddyW
Frequent Visitor
3 years ago
Solved

Goal Seek to Each Row for Effective Interest Rate

Hello Everyone,   Before I explain what my problem is, please read my case first:   Company A have to loan using 2 source of fund, which backed up by loan and capital, respectively 70% and 30%. T...
Need Help
  • ImkeF's avatar
    ImkeF
    3 years ago

    Hi EddyW ,
    if you want a fast calculation, I strongly recommend to use DAX in this case. Using the RATE function after using the PMT-function does the trick. See enclosed file. 150k rows load in a couple of seconds.

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

Hi EddyW ,
if you want a fast calculation, I strongly recommend to use DAX in this case. Using the RATE function after using the PMT-function does the trick. See enclosed file. 150k rows load in a couple of seconds.

  • EddyW's avatar
    EddyW
    Frequent Visitor
    3 years ago

    Hello ImkeF 

    Thank you so much for the DAX formula. It's really frustrating for me to calculate those using goalseek vba 😂. By the way, i would like to ask again. Since it is still related to this question and i'm still new here, may i ask something again over here or i should ask in another discussion?

     

    Best Regards,

    Eddy W.