D David Biddulph Mar 2, 2005 #2 Dr. Sachin Wagh said: P=1000 N=5 (years) P*(1+R)^N=1403 How do I get the value of R Click to expand... The easy way is Tools > Goal Seek Another way is that R= ((1403/P)^(1/N))-1
Dr. Sachin Wagh said: P=1000 N=5 (years) P*(1+R)^N=1403 How do I get the value of R Click to expand... The easy way is Tools > Goal Seek Another way is that R= ((1403/P)^(1/N))-1
G Guest Mar 2, 2005 #5 another way! Thanx JE McGimpsey said: One way: =RATE(N,0,-P,1403) Click to expand...