Most commonly used Excel formulas (functions):

[Kasomi]

Excel has a wide range of formulas (also called functions), each serving different purposes like calculations, text manipulation, date/time, lookup, logic, statistics, and more.

Here's a categorized list of most commonly used Excel formulas (functions):


1. Arithmetic Functions

FormulaDescription

=SUM(A1:A10)Adds values
=AVERAGE(A1:A10)Calculates the average
=MIN(A1:A10)Returns the smallest number
=MAX(A1:A10)Returns the largest number
=PRODUCT(A1:A3)Multiplies values
=ROUND(A1, 2)Rounds number to 2 decimal places
=INT(A1)Rounds down to nearest whole number
=MOD(A1, 2)Returns remainder of division


2. Logical Functions

FormulaDescription

=IF(A1>10, "Yes", "No")If condition is true, returns "Yes", else "No"
=AND(A1>0, B1<5)Returns TRUE if both conditions are true
=OR(A1>0, B1<5)Returns TRUE if at least one condition is true
=NOT(A1=10)Reverses the logic


3. Text Functions

FormulaDescription

=CONCATENATE(A1, B1) or =CONCAT(A1, B1)Joins text
=TEXT(A1, "dd-mm-yyyy")Formats number/date
=UPPER(A1)Converts to uppercase
=LOWER(A1)Converts to lowercase
=PROPER(A1)Capitalizes each word
=LEFT(A1, 3)Returns first 3 characters
=RIGHT(A1, 3)Returns last 3 characters
=MID(A1, 2, 3)Returns 3 characters from 2nd position
=LEN(A1)Counts number of characters
=FIND("x", A1)Finds position of "x"


4. Date & Time Functions

FormulaDescription

=TODAY()Returns current date
=NOW()Returns current date and time
=DAY(A1)Returns day of date
=MONTH(A1)Returns month
=YEAR(A1)Returns year
=HOUR(A1)Returns hour from time
=MINUTE(A1)Returns minute
=SECOND(A1)Returns seconds
=EDATE(A1, 1)Adds 1 month to date
=DATEDIF(A1, A2, "d")Difference in days


5. Lookup & Reference Functions

FormulaDescription

=VLOOKUP(lookup_value, table_array, col_index, FALSE)Vertical lookup
=HLOOKUP(lookup_value, table_array, row_index, FALSE)Horizontal lookup
=INDEX(A1:C3, 2, 1)Returns value at row 2, column 1
=MATCH(50, A1:A10, 0)Returns position of 50 in range
=LOOKUP(value, range)Basic lookup
=XLOOKUP(value, lookup_array, return_array)More advanced lookup (Excel 365+)


6. Financial Functions

FormulaDescription

=PMT(rate, nper, pv)Loan payment calculation
=FV(rate, nper, pmt)Future value of investment
=NPV(rate, value1, value2,...)Net present value
=IRR(values)Internal rate of return


7. Statistical Functions

FormulaDescription

=COUNT(A1:A10)Counts numeric cells
=COUNTA(A1:A10)Counts all non-empty cells
=COUNTBLANK(A1:A10)Counts empty cells
=MEDIAN(A1:A10)Median value
=MODE(A1:A10)Most frequent value
=STDEV.P(A1:A10)Standard deviation
=VAR.P(A1:A10)Variance


8. Information Functions

FormulaDescription

=ISNUMBER(A1)Checks if value is number
=ISTEXT(A1)Checks if value is text
=ISBLANK(A1)Checks if cell is empty
=ERROR.TYPE(A1)Returns error type


9. Array/Dynamic Functions (Excel 365+)

FormulaDescription

=FILTER(A1:A10, A1:A10>5)Filters array by condition
=SORT(A1:A10)Sorts range
=UNIQUE(A1:A10)Returns unique values
=SEQUENCE(5)Returns array from 1 to 5
=RANDARRAY(3, 2)Returns 3x2 array of random numbers

If you'd like an Excel file with examples for each, let me know and I can generate it for you. Or, if you're looking for formulas for a specific task (like payroll, budgeting, inventory, school marks, etc.), I can give a customized list.