B
Beebs
I need help. I am trying to find the amount of interest due per item.
I am using column D as dollar amount, column E as the of days
Trying to write this formula for rows 6 - 33
D * 7% / 365 * E = G
I have tried this and it doesn't work.
=SUM(G6:G33)=SUM(D6
33)%7%/365*(E3:E33)
And where do I put it and how do I get it to do the math.
I am using column D as dollar amount, column E as the of days
Trying to write this formula for rows 6 - 33
D * 7% / 365 * E = G
I have tried this and it doesn't work.
=SUM(G6:G33)=SUM(D6
And where do I put it and how do I get it to do the math.