Adds up values in a range, SUM, ADD, Finds the mean of numbers, MEAN, AVERAGE, Counts numeric values, COUNT, COUNTA, Counts non-empty cells, COUNT, COUNTA, Returns result based on condition, IF, ASIF, Finds the largest value, MAXIMUM, MAX, Finds the smallest value, MIN, MINIMUM, Returns the current date, TODAY, NOW, Returns the current date and time, TODAY, NOW, Counts number of characters, TRIM, LEN, Removes extra spaces, TRIM, LEN, Capitalizes first letter of each word, UPPER, PROPER, Converts text to uppercase, UPPER, PROPER, Converts text to lowercase, UPPER, LOWER, Extracts first 5 characters, LEFT, RIGHT, Extracts last 3 characters, LEFT, RIGHT, Extracts text from the middle, RIGHT, MID, Joins text together, CONCATENATE, REPLACE, Replaces part of text, CONCATENATE, REPLACE, Rounds number to 2 decimals, ROUND, ROUNDUP

MS Excel Functions

Leaderboard

Visual style

Options

Switch template

Continue editing: ?