Trunc/Pmt Different Results same formula same sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve B - 27 Oct 2006 00:59 GMT

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!

Reply to this Message

Fred Smith - 27 Oct 2006 01:37 GMT

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.

Signature

Regards,
Fred

> Hi,
>
[quoted text clipped - 17 lines]
>
> Thank You!

Reply to this Message

David Biddulph - 27 Oct 2006 08:01 GMT

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?

Signature

David Biddulph

> Hi,
>
[quoted text clipped - 18 lines]
>
> Thank You!

Reply to this Message

Steve B - 28 Oct 2006 00:56 GMT

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

> Are you sure that Tools/ Options/ Calculation is set to automatic?
>
[quoted text clipped - 24 lines]
> >
> > Thank You!

Reply to this Message

Steve B - 30 Oct 2006 23:33 GMT

Still baffled, any other recomendations?

Thank You..

> Are you sure that Tools/ Options/ Calculation is set to automatic?
>
[quoted text clipped - 24 lines]
> >
> > Thank You!

Reply to this Message