#1
|
|||
|
|||
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 |
#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 |