P
PatJennings
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
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