![]() |
|
#1
|
|||
|
|||
![]() Can it be that a FV formula works fine in one row and the exact same formula gives me a wrong result in the next row? Has anyone ever encountered this strange phenomenon, and if so, how did you fix it? Please help, I think I'm going crazy ![]() |
#2
|
||||
|
||||
![]()
Perhaps post a small sheet showing the problem , ( no pics please) ?
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
![]()
Notice how the balance in B9 went down (as it should after 2 months of payment), but in the following rows it goes up?
|
#4
|
|||
|
|||
![]()
Can this be of any help?
|
#5
|
|||
|
|||
![]()
Thank you. It helped me figure out what I did wrong. I forgot to divide the interest rate by 12, since payments are monthly but the interest rate is annual. Now all is working as it should. I should've known it was an operator error.
![]() |
![]() |
Tags |
fv |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Need help with dragging a formula and changing a reference column as I drag the formula. | LupeB | Excel | 1 | 10-22-2015 03:02 PM |
![]() |
ashreporter | Excel | 3 | 04-01-2015 10:40 PM |
![]() |
david_89_ | Excel | 4 | 06-11-2014 11:07 AM |
![]() |
rich_cirillo | Excel | 3 | 09-26-2012 11:41 PM |
![]() |
OneOleGuy | Excel | 4 | 03-05-2011 09:54 AM |