Complete Excel Formulas Guide
Basic Math Functions
=SUM(A1:A10) – Adds values
=AVERAGE(A1:A10) – Finds average
=MIN(A1:A10) – Smallest value
=MAX(A1:A10) – Largest value
=ROUND(A1,2) – Rounds to 2 decimals
Logical Functions
=IF(A1>10, "Pass", "Fail") – Conditional check
=AND(A1>5, B1<10) – Returns TRUE if both conditions are true
=OR(A1>5, B1<10) – Returns TRUE if any condition is true
=NOT(A1=10) – Reverses logic
Lookup & Reference Functions
=VLOOKUP(101, A2:D20, 2, FALSE) – Vertical lookup
=HLOOKUP(90, A1:H3, 2, TRUE) – Horizontal lookup
=INDEX(A1:C10, 2, 3) – Value at row 2, col 3
=MATCH(50, A1:A10, 0) – Position of 50
=XLOOKUP(105, A2:A20, B2:B20) – Modern lookup
Text Functions
=CONCAT(A1, B1) – Joins text
=TEXT(A1, "DD/MM/YYYY") – Format date
=LEFT(A1, 4) – Extracts first 4 characters
=RIGHT(A1, 3) – Extracts last 3 characters
=LEN(A1) – Counts characters
=TRIM(A1) – Removes extra spaces
Date & Time Functions
=TODAY() – Current date
=NOW() – Current date & time
=DATEDIF(A1,B1,"Y") – Years between dates
=EOMONTH(A1,1) – End of next month
=NETWORKDAYS(A1,B1) – Working days between dates
Statistical Functions
=COUNT(A1:A20) – Count numbers
=COUNTA(A1:A20) – Count all non-empty
=COUNTIF(A1:A20,">100") – Count >100
=STDEV(A1:A10) – Standard deviation
=VAR(A1:A10) – Variance
Financial Functions
=PMT(5%/12, 60, -10000) – Loan EMI
=FV(8%/12, 10*12, -200, 0) – Future value
=NPV(10%, A1:A5) – Net Present Value
=IRR(A1:A5) – Internal Rate of Return
Dynamic Array Functions (Excel 365)
=UNIQUE(A1:A20) – Unique values
=SORT(A1:A20) – Sort range
=FILTER(A1:B20, B1:B20>100) – Filter data
=SEQUENCE(10) – Generates sequence 1-10
