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

Excel Formulas

EOMONTH

  • May 31, 2023
Definition: EOMONTH is a function that returns the serial number of the last day of the month that is a specified number of months before or after a...
Read More

EQUIV

  • May 31, 2023
Definition: EQUIV is a function that returns the annual interest rate for an investment that pays interest at different intervals. Syntax: =EQUIV(nominal_rate, npery1, npery2) Situation: This formula is...
Read More

ERROR.TYPE

  • May 31, 2023
Definition: ERROR.TYPE is a function that returns a number corresponding to the type of error value in a cell. Syntax: =ERROR.TYPE(error_val) Situation: This formula is suitable when you...
Read More

EVEN

  • May 31, 2023
Definition: EVEN is a function that rounds a number up to the nearest even integer. Syntax: =EVEN(number) Situation: This formula is suitable when you need to round a...
Read More

EXACT

  • May 31, 2023
Definition: EXACT is a function that compares two text strings and returns TRUE if they are identical, otherwise it returns FALSE. Syntax: =EXACT(text1, text2) Situation: This formula is...
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

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

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

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

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