Making this simple formula
 

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:D33)%7%/365*(E3:E33)

And where do I put it and how do I get it to do the math.

Making this simple formula
 

start on row 6 and type =d6*7%/365*e6

If you want the entire number, just type =sum(D6:D33)*7%/365*(sum(E6:E33))

"Beebs" wrote:

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:D33)%7%/365*(E3:E33)

And where do I put it and how do I get it to do the math.

Making this simple formula
 

Thank you Sean. How do I get it to do this for each line 6-33 without having
to enter the formula on each line?

"Sean Timmons" wrote:

start on row 6 and type =d6*7%/365*e6

If you want the entire number, just type =sum(D6:D33)*7%/365*(sum(E6:E33))

"Beebs" wrote:

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:D33)%7%/365*(E3:E33)

And where do I put it and how do I get it to do the math.

Making this simple formula
 

I figured it out with a click and drag down. I used 4 decimal places and it
didn't match the amounts with my calculator. In the rounding on the
calculator it rounded up regardless of the number to be rounded was 5 or
above. hmmmmmm
"Sean Timmons" wrote:

start on row 6 and type =d6*7%/365*e6

If you want the entire number, just type =sum(D6:D33)*7%/365*(sum(E6:E33))

"Beebs" wrote:

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:D33)%7%/365*(E3:E33)

And where do I put it and how do I get it to do the math.