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

Excel Formulas

BIN2HEX

  • May 31, 2023
Definition: BIN2HEX is a function that converts a binary number to hexadecimal. Syntax: =BIN2HEX(number, [places]) Situation: This formula is suitable when you need to convert a binary number...
Read More

BIN2OCT

  • May 31, 2023
Definition: BIN2OCT is a function that converts a binary number to octal. Syntax: =BIN2OCT(number, [places]) Situation: This formula is suitable when you need to convert a binary number...
Read More

BINOMDIST

  • May 31, 2023
Definition: BINOMDIST is a function that returns the individual term binomial distribution probability. Syntax: =BINOMDIST(number_s, trials, probability_s, [cumulative]) Situation: This formula is suitable when you need to find...
Read More

CEILING

  • May 31, 2023
Definition: CEILING is a function that rounds a number up to the nearest multiple of a specified value. Syntax: =CEILING(number, [significance]) Situation: This formula is suitable when you...
Read More

CELL

  • May 31, 2023
Definition: CELL is a function that returns information about a cell, such as its format, contents, or location. Syntax: =CELL(info_type, [reference]) Situation: This formula is suitable when you...
Read More

AVERAGEIF

  • May 31, 2023
Definition: AVERAGEIF is a function that returns the average of a range of cells that meet a specified criterion. Syntax: =AVERAGEIF(range, criteria, [average_range]) Situation: This formula is suitable...
Read More

AVERAGEIFS

  • May 31, 2023
Definition: AVERAGEIFS is a function that returns the average of a range of cells that meet multiple specified criteria. Syntax: =AVERAGEIFS(average_range, criteria_range1, criteria1, [criteria_range2], [criteria2], ...) Situation: This...
Read More

BAHTTEXT

  • May 31, 2023
Definition: BAHTTEXT is a function that converts a number to Thai text. Syntax: =BAHTTEXT(number) Situation: This formula is suitable when you need to convert a number to Thai...
Read More

ABS

  • May 31, 2023
Definition: ABS is a function that returns the absolute value of a number. The absolute value of a number is the number without its sign. Syntax: =ABS(number) Situation:...
Read More

BASE

  • May 31, 2023
Definition: BASE is a function that converts a number from one base to another. Syntax: =BASE(number, from_base, [to_base]) Situation: This formula is suitable when you need to convert...
Read More