View Single Post
 
Old 01-19-2021, 09:56 PM
hendrikbez hendrikbez is offline Windows 7 64bit Office 2016
Novice
 
Join Date: Nov 2016
Posts: 14
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