Need to calculate 10% or 20% on investment form depending on interest rate in col C

I hope you can help me. I have attached the file I need help with. The way I have this sheet setup is to calculate a 20% fee off the interest earned column "D". Say you earned 6.5% on a beginning balance so the interest earned is in col "D". This works fine for a 20% fee but I need the fee to calculate a 10% fee if the interest in column "C" hit 4% or below and it also needs to be able to calculate a 20% fee if the interested earned is above 4%.

I have not been able to figure out a formula to do this.

Thanks,

Can you use this formula in E9, copied down?

=SUM(D9*IF(C9<=4%,10%,20%))

Actually, I went a little too fast and forgot to mention that you don't need to use the redundant Sum() function...

just... =D9*IF(C9<=4%,10%,20%) would do.

You are quite welcome,

Can you please mark your thread as Solved?

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save