Skip to content
Excel Nerds

Excel Nerds

Learn Pivot Tables, Vlookup, and Data Analysis

  • Articles
  • Videos
  • Merch
  • Excel Courses

Math Functions

  • Home
  •   »  
  • Functions
  •   »  
  • Math Functions
Functions Math Functions
RANDBETWEEN – Excel Function

RANDBETWEEN – Excel Function

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

Functions Math Functions
RAND – Excel Function

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

Functions Math Functions
AVERAGE – Excel Function

AVERAGE – Excel Function

The Average function only takes numbers as arguments, and calculates the arithmetic average of the data. These numbers can be

Functions Math Functions
SMALL – Excel Function

SMALL – Excel Function

What it does: The SMALL() Function provides the n-th smallest piece of data from an array. Plain English: The SMALL()

Functions Math Functions
LARGE – Excel Function

LARGE – Excel Function

What it does: The LARGE() Function provides the n-th largest piece of data from an array. Plain English: The LARGE() Function

Functions Math Functions
COUNTIFS – Excel Function

COUNTIFS – Excel Function

What it does: The COUNTIFS() Function allows you to count the number of cells that match multiple criteria. Plain English:

Functions Math Functions
SUMIF – Excel Function

SUMIF – Excel Function

What it does: The SUMIF() Functions sum together values based on criteria you provide. Plain English: The SUMIF() formula is

Functions Math Functions
COUNTA – Excel Function

COUNTA – Excel Function

What it does: The COUNTA() function counts the number of cells that are not blank Plain English: This function is similar to

Functions Math Functions
COUNTIF – Excel Function

COUNTIF – Excel Function

What it does: The COUNTIF() function counts the number of cells that meet a certain criteria. Plain English: This function is

Posts navigation

1 2 »
  • Articles
  • Videos
  • Online Training
  • About
  • Contact
  • Excel Functions
    • Text Functions
    • Math Functions
    • Logical Functions
    • Lookup and Reference Functions
Copyright ©2022 Excel Nerds - Learn Pivot Tables, Vlookup, and Data Analysis
Developed by WOWLayers.com