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

Excel Formulas

FIXED

  • May 31, 2023
Definition: FIXED is a function that rounds a number to a specified number of decimal places and formats the result with commas and a currency symbol. Syntax: =FIXED(number,...
Read More

FLOOR

  • May 31, 2023
Definition: FLOOR is a function that rounds a number down to the nearest specified multiple. Syntax: =FLOOR(number, significance) Situation: This formula is suitable when you need to round...
Read More

FORECAST

  • May 31, 2023
Definition: FORECAST is a function that predicts a future value using linear regression. Syntax: =FORECAST(x, known_y's, known_x's) Situation: This formula is suitable when you need to predict a...
Read More

FREQUENCY

  • May 31, 2023
Definition: FREQUENCY is a function that returns a frequency distribution for a set of values. Syntax: =FREQUENCY(data_array, bins_array) Situation: This formula is suitable when you need to find...
Read More

FTEST

  • May 31, 2023
Definition: FTEST is a function that returns the result of an F-test, which compares the variances of two sets of data. Syntax: =FTEST(array1, array2) Situation: This formula is...
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

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

FACT

  • May 31, 2023
Definition: FACT is a function that returns the factorial of a number. Syntax: =FACT(number) Situation: This formula is suitable when you need to find the factorial of a...
Read More

DSTDEV

  • May 31, 2023
Definition: DSTDEV is a function that returns the standard deviation of a population based on a database that meets a specified condition. Syntax: =DSTDEV(database, field, criteria) Situation: This...
Read More

FALSE

  • May 31, 2023
Definition: FALSE is a function that returns the logical value FALSE. Syntax: =FALSE() Situation: This formula is suitable when you need to return the logical value FALSE. Example:...
Read More