Still baffled, any other recomendations?

Thank You..

"David Biddulph" wrote:

Are you sure that Tools/ Options/ Calculation is set to automatic?

Interestingly, you'll find that you'll get the answer 227.16 if G33 is
minus 6917.4, instead of plus, so did you have that value at one stage (or
+G33 in the formula instead of -G33), calculated one cell, then changed it
and calculated the other cell, with calculation set to manual?
--
David Biddulph

"Steve B" wrote in message
...
Hi,

I have the same formula twice in the same spreadsheet and am getting two
different results, even copied and pasted and made sure the cell
references
aligned, happend over and over again with this formula.

Here are both versions:
=TRUNC((PMT(G28/1200,G10,-G26-G33*(1+G28/1200)^-(G10+1))/(1+G28/1200))*100)/100

=TRUNC((PMT(G28/1200,G10,-G26-G33*(1+G28/1200)^-(G10+1))/(1+G28/1200))*100)/100
Whe
G10=48
G26= 14176.52
G28= 8.5
G33= 6917.4

I get 227.16 and 466.77. Does the Trunc mess it up?

Any guidance is appreciatedd, need more info?

Thank You!