Vous êtes sur le site Web historique de la documentation de 4D. Les documentations sont progressivement déplacées vers developer.4d.com
- 4D View Pro
-
- Formules 4D View Pro
-
-
Opérateurs et valeurs
-
Références des cellules
-
Conversion des formules du plug-in 4D View
-
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
RATE
RATE
| RATE ( n , m , p {, f} ) | ||||||||
| Paramètre | Type | Description | ||||||
| n | Numérique |
|
The number of periods | |||||
| m | Numérique |
|
The monthly payment paid at the end of the period (use a negative number). For future value: pass an empty parameter (see example) |
|||||
| p | Numérique |
|
The current value of the loan | |||||
| f | Numérique |
|
The future value (use a negative number) | |||||
The RATE function returns the interest rate corresponding to the values passed in parameters. Two formulas can be used:
- First formula, when you know the monthly payment paid at the end of the period
- Second formula, when you know the acquired value:
You borrowed 3,000 euros and your monthly payments are 1,000 euros over 5 months:
RATE(5,-1000,3000) //0.19You borrowed 2,800 euros and the total paid value is 6,000 euros over 5 months:
RATE(5,,2800,-6000) //0.16
Voir aussi
PROPRIÉTÉS
Produit : 4D
Thème : Formules 4D View Pro
PAGE CONTENTS
HISTORIQUE
UTILISATION DE L'ARTICLE
4D View Pro ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. Tous droits réservés.