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

Math

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

HEX2BIN

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

HEX2DEC

  • May 31, 2023
Definition: HEX2DEC is a function that converts a hexadecimal number to decimal. Syntax: =HEX2DEC(number) Situation: This formula is suitable when you need to convert a hexadecimal number to...
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

DSUM

  • May 31, 2023
Definition: DSUM is a function that sums the values in a database that meet a specified condition. Syntax: =DSUM(database, field, criteria) Situation: This formula is suitable when you...
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

DEC2BIN

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

DEC2HEX

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

DEC2OCT

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

DELTA

  • May 31, 2023
Definition: DELTA is a function that compares two values and returns 1 if the values are equal, otherwise it returns 0. Syntax: =DELTA(value1, [value2]) Situation: This formula is...
Read More