| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need help making a formula | Excel Worksheet Functions | |||
| IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
| Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
| Making too much of a formula | Excel Worksheet Functions | |||
| Making this formula work | Excel Worksheet Functions | |||
Linear Mode
