Functions Math & Trig(Microsoft Excel Functions)

01/09/202301/25/2023

Contents

1. Aggregate Functions.
- 1.1. Sum total.
  - 1.1.1. SUM Function. Sums numbers.
  - 1.1.2. SUMIF function. Sum the values of cells matching the criteria.
2. MOD function. Surplus.
3. RANDBETWEEN function. Obtains a random number within the specified range.
4. RANDARRAY function. Random numbers in multiple cells.
5. GCD function. The greatest common divisor.
6. LCM Function.Least common multiple.

Aggregate Functions.

Sum total.

SUM Function. Sums numbers.

SUM Function. Sums numbers.(Microsoft Excel)

SUMIF function. Sum the values of cells matching the criteria.

SUMIF function. Sum the values of cells matching the criteria.(Microsoft Excel)

MOD function. Surplus.

MOD function. Surplus.(Microsoft Excel)

RANDBETWEEN function. Obtains a random number within the specified range.

RANDBETWEEN function. Obtains a random number within the specified range.

RANDARRAY function. Random numbers in multiple cells.

RANDBETWEEN function. Obtains a random number within the specified range.

GCD function. The greatest common divisor.

GCD function. The greatest common divisor.(Microsoft Excel)

LCM Function.Least common multiple.

LCM Function.Least common multiple.(Microsoft Excel)