Trunc/Pmt Different Results same formula same sheet

[Steve B]

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
Where:
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!

 

[Fred Smith]

I copied both your formulas and pasted them several times. I always got 466.77
as my answer.
There must be a difference between them you are not seeing.

 

[David Biddulph]

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?

 

[Steve B]

Thank you for your reply,

In Both instances the tools/options is automatic. After some
playing,changing the -g33 to postive gives me the negaitve 227.16. In the
original formula, if I erase "trunc", it gives me the 466 answer. Is there
some other formatting or conditioning of the cell that will do this? I
checked conditional formatting, and nothing is there. Funny to, if I make
adjustments to the cell reference, ie change from G33 to $G$33, it completly
changes the result from 227.16 to 466.77. This is me now : (Hit head to wall).

Can I send the spreadsheet to anybody to review, or other thoughts?

Thanks and a good weekend to all

 

[Steve B]

Still baffled, any other recomendations?

Thank You..