This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
-
Operators and values
-
Cell references
-
Converting 4D View plug-in formulas
-
ABS
-
ACOS
-
AND
-
ASIN
-
ATAN
-
AVERAGE
-
COLUMNLETTER
-
COS
-
COUNTA
-
EXP
-
FALSE
-
FINDCELL
-
FV
-
IF
-
INDIRECT
-
ISBLANK
-
LEN
-
LN
-
LOOKUP
-
MAX
-
MID
-
MIN
-
NOT
-
NOW
-
NPER
-
OR
-
PI
-
PMT
-
PV
-
RAND
-
RATE
-
ROUND
-
ROW
-
RUNTIME_CURRENT_TIME
-
RUNTIME_DATE
-
RUNTIME_STRING
-
RUNTIME_TIME
-
RUNTIME_VIEW_STRING
-
SIN
-
SQRT
-
STDEV.P
-
SUBSTITUTE
-
SUM
-
TAN
-
TEXT
-
TODAY
-
TRUE
-
TYPE
-
VAR.P
-
4D v19
NPER
NPER
| NPER ( i , m , p {, f} ) | ||||||||
| Parameter | Type | Description | ||||||
| i | Number |
|
The interest rate for a period | |||||
| m | Number |
|
The monthly payment paid at the end of the period (use a negative value). For acquired value: pass an empty parameter (see example) |
|||||
| p | Number |
|
The current value of the loan | |||||
| f | Number |
|
The future value of the loan (use a negative value) | |||||
The NPER function returns the number of periods needed to reimburse a loan. Two formulas can be used:
- First formula, when you know the monthly payment:
- Second formula, when you know the total payment:
You borrowed 6,500 euros with 10.5% annual interest and you reimburse 166.42 euros per month:
NPER(10.5%/12,-166.42,6500) //48You borrowed 3,000 euros with 10.5% annual interest and you know that the total monthly payments will be 5,000 euros:
NPER(10.5%/12,,3000,-5000) //58
PROPERTIES
Product: 4D
Theme: 4D View Pro Formulas
PAGE CONTENTS
HISTORY
ARTICLE USAGE
4D View Pro Reference ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. All rights reserved.