Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-27-2016, 09:02 AM
beafloor beafloor is offline FV Formula Windows XP FV Formula Office 2013
Novice
FV Formula
 
Join Date: May 2016
Posts: 3
beafloor is on a distinguished road
Default FV Formula


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
Reply With Quote
  #2  
Old 05-27-2016, 09:26 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline FV Formula Windows 7 64bit FV Formula Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

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
Reply With Quote
  #3  
Old 05-27-2016, 10:28 AM
beafloor beafloor is offline FV Formula Windows XP FV Formula Office 2013
Novice
FV Formula
 
Join Date: May 2016
Posts: 3
beafloor is on a distinguished road
Default

Notice how the balance in B9 went down (as it should after 2 months of payment), but in the following rows it goes up?
Attached Files
File Type: xlsx FV Trouble.xlsx (12.1 KB, 12 views)
Reply With Quote
  #4  
Old 05-27-2016, 11:22 AM
xor xor is offline FV Formula Windows 10 FV Formula Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,100
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can this be of any help?
Attached Files
File Type: xlsx FV Trouble_2.xlsx (12.7 KB, 10 views)
Reply With Quote
  #5  
Old 05-31-2016, 05:30 AM
beafloor beafloor is offline FV Formula Windows XP FV Formula Office 2013
Novice
FV Formula
 
Join Date: May 2016
Posts: 3
beafloor is on a distinguished road
Default

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. Thank you for your help.
Reply With Quote
Reply

Tags
fv



Similar Threads
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
FV Formula Formula Help ashreporter Excel 3 04-01-2015 10:40 PM
FV Formula IF + AND formula help david_89_ Excel 4 06-11-2014 11:07 AM
FV Formula formula help rich_cirillo Excel 3 09-26-2012 11:41 PM
FV Formula PMT Formula OneOleGuy Excel 4 03-05-2011 09:54 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:09 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft