Top 100 Excel Formulas (With Uses)
Formula Use
=SUM() Adds a range of numbers
=AVERAGE() Calculates the average of numbers
=MIN() Returns the smallest number
=MAX() Returns the largest number
=COUNT() Counts numeric cells
=COUNTA() Counts non-empty cells
=IF() Performs logical test and returns values based on condition
=IFERROR() Returns value if error occurs, else result
=IFS() Multiple conditions in a single formula
=VLOOKUP() Searches value in a column and returns result from another column
=HLOOKUP() Searches value in a row and returns result from another row
=XLOOKUP() Modern lookup replacing VLOOKUP/HLOOKUP
=INDEX() Returns value at a given position in a range
=MATCH() Returns position of a value in a range
=INDEX MATCH Powerful lookup combining INDEX and MATCH
=LEN() Counts number of characters in a string
=TRIM() Removes extra spaces from text
=PROPER() Capitalizes first letter of each word
=UPPER() Converts text to uppercase
=LOWER() Converts text to lowercase
=LEFT() Extracts characters from the start
=RIGHT() Extracts characters from the end
=MID() Extracts characters from the middle
=CONCATENATE() Joins text from multiple cells
=TEXTJOIN() Joins text with delimiter
=TEXT() Formats number/date using format codes
=NOW() Returns current date and time
=TODAY() Returns current date
=DAY() Returns day from date
=MONTH() Returns month from date
Top 100 Excel Formulas (With Uses)
=YEAR() Returns year from date
=WEEKDAY() Returns day number of the week
=NETWORKDAYS() Calculates workdays between two dates
=EDATE() Returns date after adding months
=EOMONTH() End of month from given date
=RAND() Generates random number (0-1)
=RANDBETWEEN() Generates random integer between two numbers
=ROUND() Rounds number to specific digits
=ROUNDUP() Rounds number up
=ROUNDDOWN() Rounds number down
=CEILING() Rounds number up to nearest multiple
=FLOOR() Rounds number down to nearest multiple
=ABS() Returns absolute value (positive)
=MOD() Returns remainder after division
=POWER() Returns power of a number
=SQRT() Returns square root
=SUBTOTAL() Performs calculation on visible cells
=AGGREGATE() Performs various operations, can ignore errors
=LARGE() Returns nth largest number
=SMALL() Returns nth smallest number
=RANK() Returns rank of a number
=PERCENTILE() Returns k-th percentile
=PERCENTRANK() Returns rank as percentage
=CORREL() Correlation coefficient between two data sets
=STDEV() Standard deviation
=VAR() Variance
=TRANSPOSE() Converts rows to columns and vice versa
=UNIQUE() Returns unique values from range
=FILTER() Filters data based on criteria
=SORT() Sorts range in order
=SORTBY() Sorts based on another range
Top 100 Excel Formulas (With Uses)
=SEQUENCE() Generates sequential numbers
=ISNUMBER() Checks if value is number
=ISTEXT() Checks if value is text
=ISBLANK() Checks if cell is empty
=ISERROR() Checks if cell contains error
=NA() Returns #N/A error
=TYPE() Returns type of value
=CELL() Returns info about cell
=INFO() Returns system info
=FORMULATEXT() Displays formula in cell
=INDIRECT() Returns reference specified by a string
=OFFSET() Returns range offset from a cell
=CHOOSE() Returns value from list by position
=SWITCH() Multiple condition function (like IFS)
=AND() Returns TRUE if all conditions are true
=OR() Returns TRUE if any condition is true
=NOT() Returns opposite of a condition
=TRUE Returns logical TRUE
=FALSE Returns logical FALSE
=DAYS() Returns days between two dates
=DATEDIF() Difference between dates in years/months/days
=HOUR() Returns hour from time
=MINUTE() Returns minutes from time
=SECOND() Returns seconds from time
=TIME() Returns time from hours, minutes, seconds
=TEXTSPLIT() Splits text into columns or rows
=TEXTBEFORE() Gets text before a character
=TEXTAFTER() Gets text after a character
=LET() Assigns names to calculation steps
=LAMBDA() Creates custom functions
=MAP() Applies LAMBDA to each element in array
Top 100 Excel Formulas (With Uses)
=SCAN() Scans values step-by-step
=DROP() Drops rows/columns from array
=TAKE() Returns rows/columns from array
=VSTACK() Stacks values vertically
=HSTACK() Stacks values horizontally
=WRAPCOLS() Wraps array into columns
=WRAPROWS() Wraps array into rows
