Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-19-2021, 09:56 PM
hendrikbez hendrikbez is offline Change info in formula Windows 7 64bit Change info in formula Office 2016
Novice
Change info in formula
 
Join Date: Nov 2016
Posts: 11
hendrikbez is on a distinguished road
Default Change info in formula

=PMT(F2/12,MAANDE,-N2)
=PMT(F17/12,MAANDE,-N14)
=PMT(F18/12,MAANDE,-N15)
=PMT(F19/12,MAANDE,-N16)
=PMT(F20/12,MAANDE,-N17)
=PMT(F21/12,MAANDE,-N18)
=PMT(F2/12,MAANDE,-N19)

Is there a easy way to change all the N14/15/16/17/18....... to only N2
I have 240 that must be changed to N2
Reply With Quote
  #2  
Old 01-20-2021, 12:19 AM
ArviLaanemets ArviLaanemets is offline Change info in formula Windows 8 Change info in formula Office 2016
Expert
 
Join Date: May 2017
Posts: 873
ArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud ofArviLaanemets has much to be proud of
Default

Change the formula for row 2 to
=PMT($F2/12,MAANDE,-$N$2)
Copy the formula down for all 240 (or more?) rows;
(In case you don't need the formula for rows 3 - 13, clear contents from this range in formula column)
Reply With Quote
  #3  
Old 01-20-2021, 12:31 AM
hendrikbez hendrikbez is offline Change info in formula Windows 7 64bit Change info in formula Office 2016
Novice
Change info in formula
 
Join Date: Nov 2016
Posts: 11
hendrikbez is on a distinguished road
Default

Thank you, it worked
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Change info in formula change formula based upon change of month invgrp2 Excel 7 05-03-2018 10:46 AM
Change info in formula Possible to use an existing vlookup formula to also insert correct info and trigger a SUM formula innkeeper9 Excel 2 09-13-2016 08:59 PM
Change info in formula Does anyone know if you can keep a calendar template full o info but change the year? dartist Word 3 02-12-2014 01:28 AM
Change info in formula sumproduct formula to pull info from multiple sheets Berk21 Excel 7 01-15-2012 11:41 AM
How do I change default log-in info? RainPure Office 0 11-15-2010 05:07 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:19 PM.


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