Category: Math Functions

RANDBETWEEN – Excel Function

What it does: The RANDBETWEEN() Function generates a random number between two integers.

Plain English: Rather than generating a random number between 0 and 1, RANDBETWEEN() generates an integer between a given range of integers that you provide. For example, you may want to pick 6 random lottery numbers between 1 and 35. This formula could help generate those.

Arguments: RANDBETWEEN(lower number, higher number)

  • Lower number – the lowest integer possible you want to generate
  • Higher number – the highest integer possible you want to generate

Blog Posts using RANDBETWEEN()

  • Article 1

Videos using RANDBETWEEN()

  • Video 1

RAND – Excel Function

What it does: The RAND() Function generates a random number between 0 and 1.

Plain English: The random function is a brother to the RANDBETWEEN() function. It generates a number in between 0 and 1, like .6231. This is a great function for creating sample data or running simulations where you need a random number generated.

Syntax: RAND()

  • (no arguments needed for this function)

Blog Posts using RAND()

  • Article 1

Videos using RAND()

  • Video 1

AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be individual, in an array, or named range.

What it does: The AVERAGE() Function finds the average of the numbers (arguments) you provide.

Plain English: The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be individual, in an array, or named range.

Arguments: Average(number1,[number2])

  • Number 1 – the first number for which you want the average
  • Number 2 – optional – the second number for which you want the average.

Blog Posts using AVERAGE()

  • Article 1

Videos using AVERAGE()

  • Video 1