KG Old Wolf

Posts: n/a

Incorrect result using NPER worksheet function

I am using the NPER function to determine the number of periods required to
pay of a loan at constant rate and constant payment. The result is
consistently understated (periods are too few to pay off the loan)

Is there a known problem? Has anyone else used this function?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Amount or Numbers in Words	ron	New Users to Excel	6	December 24th 04 07:32 PM
Reference Data in Moved Worksheet	tommcbrny	Setting up and Configuration of Excel	1	December 1st 04 06:49 PM
Worksheet name and Backward compatibility	Rich	Excel Discussion (Misc queries)	3	November 30th 04 06:10 PM
about worksheet function =bahttext	Rao Ratan Singh	Excel Worksheet Functions	2	November 18th 04 09:56 PM
left worksheet function within a combo box	Billing Goddess	Excel Worksheet Functions	3	November 15th 04 08:58 PM

All times are GMT +1. The time now is 06:35 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us