| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rate Worksheet Function
Using the values in columns A, B, and C, I have the following data solving
for rate in column D. I have changed the iteration count and the minimum value under Tools, Options, Calculation to no avail. Why are the #NUM results appearing? Can the real values be solved? Thanks. A B C D E 1 206 100,000 48444% 206 2 206 100,000 2054% 412 3 206 100,000 650% 618 4 206 100,000 340% 824 5 206 100,000 220% 1030 6 206 100,000 #NUM! 1236 7 206 100,000 #NUM! 1442 8 206 100,000 #NUM! 1648 9 206 100,000 #NUM! 1854 10 206 100,000 #NUM! 2060 11 206 100,000 #NUM! 2266 12 206 100,000 #NUM! 2472 13 206 100,000 #NUM! 2678 14 206 100,000 43% 2884 15 206 100,000 39% 3090 16 206 100,000 35% 3296 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| APR - RATE Function | Excel Worksheet Functions | |||
| Rate function | Excel Worksheet Functions | |||
| How to use RATE function? | Excel Discussion (Misc queries) | |||
| How to use RATE function? | Excel Worksheet Functions | |||
| Possible Variable in Rate Function | Excel Worksheet Functions | |||
Threaded Mode
