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.