![]() |
|
#1
|
|||
|
|||
|
=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 |
|
#2
|
|||
|
|||
|
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) |
|
#3
|
|||
|
|||
|
Thank you, it worked
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
change formula based upon change of month
|
invgrp2 | Excel | 7 | 05-03-2018 10:46 AM |
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 |
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 |
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 |