Topics: Developer Forum
Jan 19, 2012 at 12:01 AM

Good day,

My issue is regarding the rate function. when i passed these value "RATE(30,13.25,-100,100,0)" using the rate function it returns -1.680338697 instead of 13.25 or .1325. All other values are returned correctly just this once instance.

But when the same function with the same value in  with excel it return the 13.25 or .1325 which is correct, and when i use the yield function with the appropriate value its return the correct value, i am using the rate the return the yield since phpexcl doesn't   support the yield function as yet. sigh :(.

can anyone assist with this issue please. thanks in advance.