Making this simple formula

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.
 
S

Sean Timmons

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))
 
B

Beebs

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?
 
B

Beebs

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top