Table of Contents

📘 Top 50 Excel Formulas with Uses & Examples

ADVERTISEMENT

Formula: =SUM(A1:A5)
Use: Adds all values from A1 to A5.
Example: A1 = 10, A2 = 20, A3 = 30 → Result = 60
Formula: =AVERAGE(B1:B4)
Use: Returns average of values.
Example: B1 = 10, B2 = 20, B3 = 30, B4 = 40 → Result = 25
Formula: =IF(C1>100,"Profit","Loss")
Use: Performs conditional test.
Example: C1 = 120 → Result = "Profit"
Formula: =VLOOKUP(101,A2:C10,2,FALSE)
Use: Finds value in first column and returns value from the 2nd column.
Example: Lookup 101 and return name from column 2
Formula: =HLOOKUP("Marks",A1:Z3,2,FALSE)
Use: Horizontal lookup in top row.
Example: Find "Marks" and return next row value
Formula: =INDEX(A2:C4,2,2)
Use: Returns cell content from row 2, column 2.
Example: Returns B3 value
Formula: =MATCH(50,A1:A10,0)
Use: Returns position of 50 in range.
Example: If 50 is in A5 → Result = 5
Formula: =LEN("Excel")
Use: Counts characters in a string.
Example: Result = 5
Formula: =TRIM(" Hello ")
Use: Removes leading and trailing spaces.
Example: Result = "Hello"
Formula: =LEFT("Excel",3)
Use: Returns first 3 characters from string.
Example: Result = "Exc"
Formula: =RIGHT("Excel",2)
Use: Returns last 2 characters.
Example: Result = "el"
Formula: =CONCATENATE("Good"," ","Morning")
Use: Joins text strings.
Example: Result = "Good Morning"
Formula: =NOW()
Use: Displays current date and time.
Example: Result = Current system date & time
Formula: =TODAY()
Use: Returns current date.
Example: Result = Today's date
Formula: =DAY(TODAY())
Use: Extracts day from a date.
Example: If date = 2025-04-10 → Result = 10
Formula: =MONTH(TODAY())
Use: Returns current month number.
Example: Result = 4
Formula: =YEAR(TODAY())
Use: Returns current year.
Example: Result = 2025
Formula: =TEXT(TODAY(),"dddd")
Use: Displays day name.
Example: Result = "Thursday"
Formula: =ROUND(12.345,2)
Use: Rounds to 2 decimal places.
Example: Result = 12.35
Formula: =CEILING(4.2,1)
Use: Rounds number up to nearest integer.
Example: Result = 5
Formula: =FLOOR(4.9,1)
Use: Rounds number down.
Example: Result = 4
Formula: =INT(5.7)
Use: Removes decimals.
Example: Result = 5
Formula: =COUNTA(A1:A10)
Use: Counts non-empty cells.
Example: Result = 8 (if 8 cells have data)
Formula: =COUNTIF(A1:A10,">50")
Use: Counts values greater than 50.
Example: Result = Count of cells > 50
Formula: =SUMIF(A1:A10,">50")
Use: Sums values greater than 50.
Example: Result = Sum of values > 50
Formula: =ISNUMBER(A1)
Use: Checks if cell has number.
Example: A1 = 123 → Result = TRUE
Formula: =ISBLANK(A1)
Use: Checks if cell is empty.
Example: A1 is blank → Result = TRUE
Formula: =ISERROR(A1)
Use: Returns TRUE if error.
Example: A1 = #DIV/0! → Result = TRUE
Formula: =IFERROR(A1/B1,"Error")
Use: Handles errors.
Example: B1 = 0 → Result = "Error"
Formula: =RANDBETWEEN(1,100)
Use: Random number between 1 and 100.
Example: Result = Any number between 1 to 100
Formula: =RAND()
Use: Random decimal between 0 and 1.
Example: Result = 0.3456 (example)
Formula: =REPT("*",5)
Use: Repeats character.
Example: Result = *****
Formula: =CHAR(65)
Use: Returns character of ASCII code.
Example: Result = A
Formula: =CODE("A")
Use: Returns ASCII value.
Example: Result = 65
Formula: =SUBTOTAL(9,A1:A10)
Use: Performs subtotal with function number 9 (SUM).
Example: Result = Sum of A1:A10
Formula: =TRANSPOSE(A1:A3)
Use: Converts vertical to horizontal range.
Example: Converts column data to row
Formula: =TEXT(1234.567,"$#,##0.00")
Use: Formats number.
Example: Result = $1,234.57
Formula: =SEARCH("x","Excel")
Use: Finds position of character.
Example: Result = 2
Formula: =FIND("e","Excel")
Use: Returns position (case-sensitive).
Example: Result = 1
Formula: =REPLACE("Excel",2,2,"--")
Use: Replaces part of text.
Example: Result = E--cel
Formula: =SUBSTITUTE("Excel is easy","easy","fun")
Use: Replaces word in string.
Example: Result = Excel is fun
Formula: =PROPER("john doe")
Use: Capitalizes first letter of each word.
Example: Result = John Doe
Formula: =UPPER("excel")
Use: Converts to uppercase.
Example: Result = EXCEL
Formula: =LOWER("EXCEL")
Use: Converts to lowercase.
Example: Result = excel
Formula: =DATEDIF("1/1/2020","1/1/2025","y")
Use: Returns year difference.
Example: Result = 5
Formula: =NETWORKDAYS("1/4/2024","1/10/2024")
Use: Counts workdays.
Example: Result = 5
Formula: =WEEKDAY(TODAY())
Use: Returns day of week.
Example: Result = 5 (if Thursday)
Formula: =MOD(15,4)
Use: Returns remainder.
Example: 15 ÷ 4 = 3
Formula: =QUOTIENT(15,4)
Use: Returns integer part of division.
Example: 15 ÷ 4 = 3
Formula: =POWER(2,3)
Use: Raises 2 to power 3.
Example: Result = 8
Formula: =SQRT(25)
Use: Returns square root.
Example: Result = 5