writer
2,661
edits
Changes
Jump to navigation
Jump to search
Line 18:
Line 18: − + − +
no edit summary
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*Settlement and maturity dates should be entered either in 'date format' or 'dates returned using formulas'. If dates are not valid, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*If settlement date ≥ maturity date, Calci displays #N/A error message.
*'rate' and 'yield' values must be greater than zero, else Calci displays #N/A error message.
*'rate' and 'yield' values must be greater than or equal to zero, else Calci displays #N/A error message.
*'redemption' value must be greater than or equal to zero, else Calci displays #N/A error message.
*'redemption' value must be greater than zero, else Calci displays #N/A error message.
*The values for 'frequency' should be 1,2 or 4.
*The values for 'frequency' should be 1,2 or 4.
For Annual payment, frequency = 1,
For Annual payment, frequency = 1,