If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formula not calculating correctly
I have a formula that is simple and the answer is not correct.
I am trying to calculate the payment amount. Because the total overdrawn amount is not always even, the final payment amount might be different by a little bit. So here is the formulas that I have entered to get the answer. Payment Amount: k16/k17 Final Payment Amount: k16 - (K18*(k17-1)) The example I am working with is total overdrawn amt is 535.29 and number of payments is 6. When I use the calculator, the payments are 89.22 and the final payment is 89.19. When I use the formula above the final payment is 89.22. The only way I get 89.19 (correct answer) is to type in 535.29-446.10. What could be the problem? Total Overdrawn Amount K16 Number of Payments K17 Payment Amount K18 Final Payment Amount K19 |
#2
|
|||
|
|||
Formula not calculating correctly
The issue is that your payment amount is calculating to 89.215 not 89.22 and
is only being displayed as 89.22. If you change your payment formula to Round(k16/k17,2) you will get a pament amout of exactly 89.22 and a final payment of 89.19 -- If this helps, please remember to click yes. "Aggie G" wrote: I have a formula that is simple and the answer is not correct. I am trying to calculate the payment amount. Because the total overdrawn amount is not always even, the final payment amount might be different by a little bit. So here is the formulas that I have entered to get the answer. Payment Amount: k16/k17 Final Payment Amount: k16 - (K18*(k17-1)) The example I am working with is total overdrawn amt is 535.29 and number of payments is 6. When I use the calculator, the payments are 89.22 and the final payment is 89.19. When I use the formula above the final payment is 89.22. The only way I get 89.19 (correct answer) is to type in 535.29-446.10. What could be the problem? Total Overdrawn Amount K16 Number of Payments K17 Payment Amount K18 Final Payment Amount K19 |
#3
|
|||
|
|||
Formula not calculating correctly
Your first 5 payments aren't =K16/K17
They are presumably =ROUND(K16/K17,2) so that's what you'd put in K18 -- David Biddulph "Aggie G" wrote in message ... I have a formula that is simple and the answer is not correct. I am trying to calculate the payment amount. Because the total overdrawn amount is not always even, the final payment amount might be different by a little bit. So here is the formulas that I have entered to get the answer. Payment Amount: k16/k17 Final Payment Amount: k16 - (K18*(k17-1)) The example I am working with is total overdrawn amt is 535.29 and number of payments is 6. When I use the calculator, the payments are 89.22 and the final payment is 89.19. When I use the formula above the final payment is 89.22. The only way I get 89.19 (correct answer) is to type in 535.29-446.10. What could be the problem? Total Overdrawn Amount K16 Number of Payments K17 Payment Amount K18 Final Payment Amount K19 |
#4
|
|||
|
|||
Formula not calculating correctly
On Wed, 18 Nov 2009 11:51:01 -0800, Aggie G
wrote: I have a formula that is simple and the answer is not correct. I am trying to calculate the payment amount. Because the total overdrawn amount is not always even, the final payment amount might be different by a little bit. So here is the formulas that I have entered to get the answer. Payment Amount: k16/k17 Final Payment Amount: k16 - (K18*(k17-1)) The example I am working with is total overdrawn amt is 535.29 and number of payments is 6. When I use the calculator, the payments are 89.22 and the final payment is 89.19. When I use the formula above the final payment is 89.22. The only way I get 89.19 (correct answer) is to type in 535.29-446.10. What could be the problem? Total Overdrawn Amount K16 Number of Payments K17 Payment Amount K18 Final Payment Amount K19 Hmmm. I made the following entries: K16: 535.29 K17: 6 K18: 89.22 K19: = K16 - (K18*(K17-1)) K19 shows $89.19 Maybe you've made a typo someplace. --ron |
#5
|
|||
|
|||
Formula not calculating correctly
I think the OP had put =K16/K17 into K18, Ron.
-- David Biddulph "Ron Rosenfeld" wrote in message ... On Wed, 18 Nov 2009 11:51:01 -0800, Aggie G wrote: I have a formula that is simple and the answer is not correct. I am trying to calculate the payment amount. Because the total overdrawn amount is not always even, the final payment amount might be different by a little bit. So here is the formulas that I have entered to get the answer. Payment Amount: k16/k17 Final Payment Amount: k16 - (K18*(k17-1)) The example I am working with is total overdrawn amt is 535.29 and number of payments is 6. When I use the calculator, the payments are 89.22 and the final payment is 89.19. When I use the formula above the final payment is 89.22. The only way I get 89.19 (correct answer) is to type in 535.29-446.10. What could be the problem? Total Overdrawn Amount K16 Number of Payments K17 Payment Amount K18 Final Payment Amount K19 Hmmm. I made the following entries: K16: 535.29 K17: 6 K18: 89.22 K19: = K16 - (K18*(K17-1)) K19 shows $89.19 Maybe you've made a typo someplace. --ron |
#6
|
|||
|
|||
Formula not calculating correctly
On Wed, 18 Nov 2009 21:35:59 -0000, "David Biddulph" groups [at]
biddulph.org.uk wrote: I think the OP had put =K16/K17 into K18, Ron. -- David Biddulph slap upside the head Then he could have used: K18: =ROUND(K16/K17,2) --ron |
#7
|
|||
|
|||
Formula not calculating correctly
Agreed. That's what a couple of us told her.
-- David Biddulph "Ron Rosenfeld" wrote in message ... On Wed, 18 Nov 2009 21:35:59 -0000, "David Biddulph" groups [at] biddulph.org.uk wrote: I think the OP had put =K16/K17 into K18, Ron. -- David Biddulph slap upside the head Then he could have used: K18: =ROUND(K16/K17,2) --ron |
#8
|
|||
|
|||
Formula not calculating correctly
On Thu, 19 Nov 2009 07:42:19 -0000, "David Biddulph" groups [at]
biddulph.org.uk wrote: Agreed. That's what a couple of us told her. -- David Biddulph Yeah, I noticed that after I posted. --ron |
Thread Tools | |
Display Modes | |
|
|