Forum Discussion

Sachin_Bhangale's avatar
Sachin_Bhangale
Copper Contributor
Jan 08, 2020

Interest calculation formula

Hi Team,   I need help with interest calculation formula. Interest should be charged as 21%. So it should be C2*0.21/12.   As per my knowledge we cannot charge Interest on interest amount hence, ...
excel
Excel on mobile
PReagan's avatar
PReagan
Bronze Contributor
Jan 08, 2020

Hello Sachin_Bhangale,

 

Starting in cell E3 your formula could be:

=IF($C3*(0.21/12)<0,0,$C3*(0.21/12))

  • Sachin_Bhangale's avatar
    Sachin_Bhangale
    Copper Contributor
    Jan 08, 2020

    Hello PReagan 

     

    Thanks for your reply. Your formula doesn't give the value of column "E". I've manually calculated and updated those values so they are correct. Just want to check if there is any formula for it.

     

    Thanks

    • PReagan's avatar
      PReagan
      Bronze Contributor
      Jan 08, 2020
      Your interest values appear to be rounded to the nearest dollar. Is this what you are seeking?
      • Sachin_Bhangale's avatar
        Sachin_Bhangale
        Copper Contributor
        Jan 17, 2020
        No, that is not the only case. Please check shared excel file and if you put that formula it doesn't give the correct results.

Resources