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

Blog

EXPONDIST

  • May 31, 2023
Definition: EXPONDIST is a function that returns the exponential distribution for a specified set of parameters. Syntax: =EXPONDIST(x, lambda, [cumulative]) Situation: This formula is suitable when you need...
Read More

EXP

  • May 31, 2023
Definition: EXP is a function that returns the result of the constant e raised to a specified power. Syntax: =EXP(number) Situation: This formula is suitable when you need...
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

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

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

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

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

EFFECT

  • May 31, 2023
Definition: EFFECT is a function that returns the effective annual interest rate based on a nominal interest rate and the number of compounding periods per year. Syntax: =EFFECT(nominal_rate,...
Read More

EDATE

  • May 31, 2023
Definition: EDATE is a function that returns the serial number of the date that is a specified number of months before or after a specified date. Syntax: =EDATE(start_date,...
Read More

DVARP

  • May 31, 2023
Definition: DVARP is a function that returns the variance of a population based on an entire database. Syntax: =DVARP(database, field) Situation: This formula is suitable when you need...
Read More