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

Math

DPRODUCT

  • May 31, 2023
Definition: DPRODUCT is a function that multiplies the values in a database that meet a specified condition. Syntax: =DPRODUCT(database, field, criteria) Situation: This formula is suitable when you...
Read More

CONVERT

  • May 31, 2023
Definition: CONVERT is a function that converts a number from one measurement system to another. Syntax: =CONVERT(number, from_unit, to_unit) Situation: This formula is suitable when you need to...
Read More

BIN2DEC

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

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

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

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