Sigma Squared
Lexington, KY, USA
614-973-9100
Follow on:
Linkedin-in Twitter Youtube

Finance

DISC

  • May 31, 2023
Definition: DISC is a function that returns the discount rate for a security. Syntax: =DISC(settlement, maturity, pr, redemption, [basis]) Situation: This formula is suitable when you need to...
Read More

DOLLARDE

  • May 31, 2023
Definition: DOLLARDE is a function that converts a decimal number to text with a currency format based on a specified fraction. Syntax: =DOLLARDE(fractional_value, [decimals]) Situation: This formula is...
Read More

DOLLARFR

  • May 31, 2023
Definition: DOLLARFR is a function that converts a fractional value to text with a currency format based on a specified fraction. Syntax: =DOLLARFR(fraction, [decimals]) Situation: This formula is...
Read More

CUMIPMT

  • May 31, 2023
Definition: CUMIPMT is a function that returns the cumulative interest paid on a loan between two periods. Syntax: =CUMIPMT(rate, nper, pv, start_period, end_period, type) Situation: This formula is...
Read More

CUMPRINC

  • May 31, 2023
Definition: CUMPRINC is a function that returns the cumulative principal paid on a loan between two periods. Syntax: =CUMPRINC(rate, nper, pv, start_period, end_period, type) Situation: This formula is...
Read More