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

Blog

DCOUNTA

  • May 31, 2023
Definition: DCOUNTA is a function that counts the number of non-blank cells in a database that meet a specified condition. Syntax: =DCOUNTA(database, field, criteria) Situation: This formula is...
Read More

DCOUNT

  • May 31, 2023
Definition: DCOUNT is a function that counts the number of cells in a database that meet a specified condition. Syntax: =DCOUNT(database, field, criteria) Situation: This formula is suitable...
Read More

DB

  • May 31, 2023
Definition: DB is a function that returns the depreciation of an asset for a specified period using the fixed-declining balance method. Syntax: =DB(cost, salvage, life, period, [month]) Situation:...
Read More

DAYS360

  • May 31, 2023
Definition: DAYS360 is a function that returns the number of days between two dates based on a 360-day year. Syntax: =DAYS360(start_date, end_date, [method]) Situation: This formula is suitable...
Read More

DAY

  • May 31, 2023
Definition: DAY is a function that returns the day of the month for a specified date. Syntax: =DAY(date) Situation: This formula is suitable when you need to retrieve...
Read More

DATEVALUE

  • May 31, 2023
Definition: DATEVALUE is a function that returns the serial number of a date based on a text string. Syntax: =DATEVALUE(date_text) Situation: This formula is suitable when you need...
Read More

DATEDIF

  • May 31, 2023
Definition: DATEDIF is a function that returns the difference between two dates in months, days, or years. Syntax: =DATEDIF(start_date, end_date, unit) Situation: This formula is suitable when you...
Read More

DATE

  • May 31, 2023
Definition: DATE is a function that returns the serial number of a date. Syntax: =DATE(year, month, day) Situation: This formula is suitable when you need to convert a...
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

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