donm

Posts: n/a

Using the RATE function in Excel, I get a NUM error.

Hi Everyone,
I'm using the formula RATE to find out the growth rate for the number of
periods of 10 years, the payment of 0, present value .43, and the future
value of 2.11. I always get the error "NUM". I wonder if something is
formatted incorrectly. I don't put values in for type and guess. I'm not sure
what else to do.

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
CONVERT Function Disappered in Excel	Gord Dibben	Excel Discussion (Misc queries)	3	April 13th 05 07:59 PM
error opening excel 2000 files	jch	Excel Discussion (Misc queries)	0	March 22nd 05 04:25 PM
error opening excel file	jp	New Users to Excel	1	February 19th 05 01:22 AM
error opening excel file	jp	Excel Worksheet Functions	0	February 16th 05 09:06 AM
CHR() function not working in Excel 2003	Richard Jonas	Excel Discussion (Misc queries)	4	February 16th 05 08:45 AM

All times are GMT +1. The time now is 08:12 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us