software

Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
formula, however the results do not seem correct. I even entered the sample
from Help and it did not return the result that is shown in Help. I did the
Error Checking function and it came back with no errors

What values did you use and what result did you get?

--
Kind regards,

Niek Otten

quot;pcsskiquot; gt; wrote in message ...
| Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
| formula, however the results do not seem correct. I even entered the sample
| from Help and it did not return the result that is shown in Help. I did the
| Error Checking function and it came back with no errors
Just to clarrify, I entered the quot;CUMPRINCquot; in a cell with the corresponding 6
items that the formula needs and it returned the quot;#NAME?quot;. So I then
installed the Analysis Toolpak and the quot;#NAME?quot; went away and a number was
returned. However the number did not seem right. So to check to see if there
is an error I thought I would enter the sample numbers from the example in
the quot;CUMPRINCquot; Excel Help page: =CUMPRINC(9/12,360,125000,1,1,0) ...This is
for a 30 year loan of $125,000 @ 9% interest and is supposed to figure the
principle paid in a single (1) payment in the first (1) month. The zero (0)
at the end of the problem means the payment is at the end of the period The
amount the Excel example says it is supposed to be is: -68.27827 ... the
amount I got in my spreadsheet was: 0

If you have any suggestions or if you have used this formula succesfully
and have some samples you are willing to share I would appreciate it.

Thanks for your interest.

pcsski

quot;Niek Ottenquot; wrote:

gt; What values did you use and what result did you get?
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;pcsskiquot; gt; wrote in message ...
gt; | Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
gt; | formula, however the results do not seem correct. I even entered the sample
gt; | from Help and it did not return the result that is shown in Help. I did the
gt; | Error Checking function and it came back with no errors
gt;
gt;
gt;

=CUMPRINC(0.09/12,360,125000,1,1,0)

percentages are stored as fractions

--
Kind regards,

Niek Otten

quot;pcsskiquot; gt; wrote in message ...
| Just to clarrify, I entered the quot;CUMPRINCquot; in a cell with the corresponding 6
| items that the formula needs and it returned the quot;#NAME?quot;. So I then
| installed the Analysis Toolpak and the quot;#NAME?quot; went away and a number was
| returned. However the number did not seem right. So to check to see if there
| is an error I thought I would enter the sample numbers from the example in
| the quot;CUMPRINCquot; Excel Help page: =CUMPRINC(9/12,360,125000,1,1,0) ...This is
| for a 30 year loan of $125,000 @ 9% interest and is supposed to figure the
| principle paid in a single (1) payment in the first (1) month. The zero (0)
| at the end of the problem means the payment is at the end of the period The
| amount the Excel example says it is supposed to be is: -68.27827 ... the
| amount I got in my spreadsheet was: 0
|
| If you have any suggestions or if you have used this formula succesfully
| and have some samples you are willing to share I would appreciate it.
|
| Thanks for your interest.
|
| pcsski
|
| quot;Niek Ottenquot; wrote:
|
| gt; What values did you use and what result did you get?
| gt;
| gt; --
| gt; Kind regards,
| gt;
| gt; Niek Otten
| gt;
| gt; quot;pcsskiquot; gt; wrote in message ...
| gt; | Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
| gt; | formula, however the results do not seem correct. I even entered the sample
| gt; | from Help and it did not return the result that is shown in Help. I did the
| gt; | Error Checking function and it came back with no errors
| gt;
| gt;
| gt;
Duh, I looked at the example and it reads quot;9.00%quot; and I'm sure the cell is
formated to make the 9.00% gt; 0.09. When I changed it it worked. Thanks for
your help!

pcsski

quot;Niek Ottenquot; wrote:

gt; =CUMPRINC(0.09/12,360,125000,1,1,0)
gt;
gt; percentages are stored as fractions
gt;
gt; --
gt; Kind regards,
gt;
gt; Niek Otten
gt;
gt; quot;pcsskiquot; gt; wrote in message ...
gt; | Just to clarrify, I entered the quot;CUMPRINCquot; in a cell with the corresponding 6
gt; | items that the formula needs and it returned the quot;#NAME?quot;. So I then
gt; | installed the Analysis Toolpak and the quot;#NAME?quot; went away and a number was
gt; | returned. However the number did not seem right. So to check to see if there
gt; | is an error I thought I would enter the sample numbers from the example in
gt; | the quot;CUMPRINCquot; Excel Help page: =CUMPRINC(9/12,360,125000,1,1,0) ...This is
gt; | for a 30 year loan of $125,000 @ 9% interest and is supposed to figure the
gt; | principle paid in a single (1) payment in the first (1) month. The zero (0)
gt; | at the end of the problem means the payment is at the end of the period The
gt; | amount the Excel example says it is supposed to be is: -68.27827 ... the
gt; | amount I got in my spreadsheet was: 0
gt; |
gt; | If you have any suggestions or if you have used this formula succesfully
gt; | and have some samples you are willing to share I would appreciate it.
gt; |
gt; | Thanks for your interest.
gt; |
gt; | pcsski
gt; |
gt; | quot;Niek Ottenquot; wrote:
gt; |
gt; | gt; What values did you use and what result did you get?
gt; | gt;
gt; | gt; --
gt; | gt; Kind regards,
gt; | gt;
gt; | gt; Niek Otten
gt; | gt;
gt; | gt; quot;pcsskiquot; gt; wrote in message ...
gt; | gt; | Excel 2002. I believe I am entering the 6 items properly in the CUMPRINC
gt; | gt; | formula, however the results do not seem correct. I even entered the sample
gt; | gt; | from Help and it did not return the result that is shown in Help. I did the
gt; | gt; | Error Checking function and it came back with no errors
gt; | gt;
gt; | gt;
gt; | gt;
gt;
gt;
gt;