Making this simple formula

  • Thread starter Thread starter Beebs
  • Start date Start date
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:D33)%7%/365*(E3:E33)

And where do I put it and how do I get it to do the math.
 
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))
 
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?
 
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
 
Back
Top