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

Blog

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

FISHERINV

  • May 31, 2023
Definition: FISHERINV is a function that returns the inverse of the Fisher transformation of a specified value. Syntax: =FISHERINV(y) Situation: This formula is suitable when you need to...
Read More

FISHER

  • May 31, 2023
Definition: FISHER is a function that returns the Fisher transformation of a specified value. Syntax: =FISHER(x) Situation: This formula is suitable when you need to find the Fisher...
Read More

FINV

  • May 31, 2023
Definition: FINV is a function that returns the inverse of the F probability distribution for a specified set of parameters. Syntax: =FINV(probability, degrees_freedom1, degrees_freedom2) Situation: This formula is...
Read More

FINFO

  • May 31, 2023
Definition: FINFO is a function that returns information about a file. Syntax: =FINFO(filename, [file_info]) Situation: This formula is suitable when you need to obtain information about a file....
Read More

FINDB

  • May 31, 2023
Definition: FINDB is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence, counting each double-byte...
Read More

FIND

  • May 31, 2023
Definition: FIND is a function that searches for a specified text string within another text string, and returns the starting position of the first occurrence. Syntax: =FIND(find_text, within_text,...
Read More

FDIST

  • May 31, 2023
Definition: FDIST is a function that returns the F probability distribution for a specified set of parameters. Syntax: =FDIST(x, degrees_freedom1, degrees_freedom2) Situation: This formula is suitable when you...
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

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