MATHEMATICAL & STATISTICAL EXCEL FUNCTIONS

Excel formulas are powerful tools that help automate calculations and data analysis. Here are some essential functions:

➤ =SUM(A1:A10) – Adds all values from A1 to A10.
➤ =AVERAGE(B1:B10) – Finds the average of values in B1 to B10.
➤ =IF(C1>50, "Pass", "Fail") – Returns "Pass" if C1 is greater than 50, otherwise "Fail".
➤ =VLOOKUP(101, A2:C10, 2, FALSE) – Searches for 101 in column A and returns a value from column 2.
➤ =HLOOKUP(50, A1:D5, 3, FALSE) – Finds 50 in row 1 and returns a value from row 3.
➤ =INDEX(A2:C5, 2, 3) – Retrieves the value at row 2, column 3 in A2:C5.
➤ =MATCH(25, A1:A10, 0) – Returns the position of 25 in the range A1:A10.
➤ =CONCATENATE(A1, " ", B1) – Joins text in A1 and B1 with a space.
➤ =LEFT(A1, 5) – Extracts the first 5 characters from A1.
➤ =RIGHT(A1, 4) – Extracts the last 4 characters from A1.
➤ =MID(A1, 3, 4) – Extracts 4 characters starting from position 3 in A1.
➤ =LEN(A1) – Counts the total number of characters in A1.
➤ =TRIM(A1) – Removes extra spaces, keeping only single spaces between words.
➤ =UPPER(A1) – Converts text in A1 to uppercase.
➤ =LOWER(A1) – Converts text in A1 to lowercase.
➤ =PROPER(A1) – Capitalizes the first letter of each word in A1.
➤ =NOW() – Returns the current date and time.
➤ =TODAY() – Returns the current date without the time.
➤ =ROUND(A1, 2) – Rounds the value in A1 to 2 decimal places.
➤ =COUNT(A1:A10) – Counts the number of numeric values in A1:A10.