Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trunc/Pmt Different Results same formula same sheet
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trunc/Pmt Different Results same formula same sheet
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. -- Regards, Fred "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! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trunc/Pmt Different Results same formula same sheet
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! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trunc/Pmt Different Results same formula same sheet
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 "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! |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Trunc/Pmt Different Results same formula same sheet
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning Values | Excel Discussion (Misc queries) | |||
Sum up columns in different sheet with error check | Excel Discussion (Misc queries) | |||
How to move a formula from one sheet to another | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |