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

Math

OCT2HEX

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

ODD

  • May 31, 2023
Definition: ODD is a function that rounds a number up to the nearest odd integer. Syntax: =ODD(number) Situation: This formula is appropriate when you need to round a...
Read More

MOD

  • May 31, 2023
Definition: MOD is a function that returns the remainder of a division operation. Syntax: =MOD(number, divisor) Situation: This formula is appropriate when you need to find the remainder...
Read More

MROUND

  • May 31, 2023
Definition: MROUND is a function that rounds a number to the nearest multiple of a specified value. Syntax: =MROUND(number, multiple) Situation: This formula is appropriate when you need...
Read More

LN

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

LOG

  • May 31, 2023
Definition: LOG is a function that returns the logarithm of a number to a specified base. Syntax: =LOG(number, [base]) Situation: This formula is appropriate when you need to...
Read More

LOG10

  • May 31, 2023
Definition: LOG10 is a function that returns the base 10 logarithm of a number. Syntax: =LOG10(number) Situation: This formula is appropriate when you need to find the base...
Read More

LOGINV

  • May 31, 2023
Definition: LOGINV is a function that returns the inverse of the cumulative distribution function for a specified log-normal distribution. Syntax: =LOGINV(probability, mean, standard_dev) Situation: This formula is appropriate...
Read More

HEX2OCT

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

INT

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