Examples of commonly used formulas Type of Formula Example Conditional Create conditional formulas Check if a number is greater than or less than another number Display or hide zero values Hide error values and error indicators in cells Lookup Look up values in a list of data Date and Time Add dates Add times Calculate the difference between two dates Calculate the difference between two times Count days before a date Show dates as days of the week Insert the current date and time in a cell Insert Julian dates Financial Calculate a running balance Calculate a compound annual growth rate (CAGR) Statistical Calculate the average of a group of numbers Calculate the median of a group of numbers Calculate the mode of a group of numbers Math Add numbers Subtract numbers Multiply numbers Divide numbers Calculate percentages Round a number Raise a number to a power Calculate the smallest or largest number in a range Calculate the factorial or permutation of a number Create a multiplication table Counting Count cells that contain numbers Count nonblank cells Count how often a value occurs Count unique values among duplicates Count numbers greater than or less than a number Calculate a running total Count all of the cells in a range Count the number of words in a cell or range Conversion Convert times Convert measurements Convert numbers to different number systems Convert Arabic to Roman numerals Text Change the case of text Check if a cell contains text (case-insensitive) Check if a cell contains text (case-sensitive) Combine text and numbers Combine text with a date or time Combine first and last names Combine two or more columns by using a function Repeat a character in a cell Display only the last four digits of identification numbers Remove spaces and nonprinting characters from text Remove characters from text Insert the current Excel file name, path, or worksheet in a cell Split names by using the Convert Text to Columns Wizard Split text among columns by using functions