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!