View Single Post
 
Old 01-20-2021, 12:19 AM
ArviLaanemets ArviLaanemets is online now Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
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