Complete Excel Formulas Guide - 50+ Essential Formulas for Office Work

Complete Excel Formulas Guide - 50+ Essential Formulas for Office Work

October 23, 2025

📊 BASIC FORMULAS

SUM Formula
excel
```
=SUM(A1:A10)
```
Use: Adds numbers in range
Example: Total sales, salary calculation
AVERAGE Formula
excel
```
=AVERAGE(B2:B20)
```
Use: Calculates average
Example: Average performance, monthly expenses
COUNT Formula
excel
```
=COUNT(A1:A10)
```
Use: Counts numeric cells
Example: Employee count, project count
COUNTA Formula
excel
```
=COUNTA(A1:A10)
```
Use: Counts non-empty cells
Example: Attendance tracking, data entries
MAX Formula
excel
```
=MAX(C2:C100)
```
Use: Finds highest value
Example: Highest sales, maximum salary
MIN Formula
excel
```
=MIN(C2:C100)
```
Use: Finds lowest value
Example: Lowest performance, minimum score

🔍 LOOKUP FORMULAS

VLOOKUP Formula
excel
```
=VLOOKUP(A2,DataRange,2,FALSE)
```
Use: Vertical data search
Example: Employee records, price lists
HLOOKUP Formula
excel
```
=HLOOKUP("Salary",A1:Z2,2,FALSE)
```
Use: Horizontal data search
Example: Comparison tables, header-based search
XLOOKUP Formula
excel
```
=XLOOKUP(A2,SearchRange,ReturnRange)
```
Use: Modern lookup (Excel 365)
Example: Flexible data searching

❓ CONDITIONAL FORMULAS

IF Formula
excel
```
=IF(A2>1000,"Bonus","No Bonus")
```
Use: Conditional logic
Example: Performance bonus, eligibility check
SUMIF Formula
excel
```
=SUMIF(DepartmentRange,"Sales",SalaryRange)
```
Use: Conditional sum
Example: Department-wise totals
SUMIFS Formula
excel
```
=SUMIFS(SalaryRange,DeptRange,"IT",ExpRange,">5")
```
Use: Multiple condition sum
Example: Filtered salary calculations
COUNTIF Formula
excel
```
=COUNTIF(StatusRange,"Completed")
```
Use: Conditional count
Example: Completed projects count
COUNTIFS Formula
excel
```
=COUNTIFS(DeptRange,"HR",ExpRange,">=3")
```
Use: Multiple condition count
Example: Employee categorization
IFS Formula
excel
```
=IFS(A1>90,"A",A1>80,"B",A1>70,"C")
```
Use: Multiple conditions
Example: Grade calculation, rating system

📅 DATE & TIME FORMULAS

TODAY Formula
excel
```
=TODAY()
```
Use: Current date
Example: Reports, deadlines
NOW Formula
excel
```
=NOW()
```
Use: Current date and time
Example: Timestamp, tracking
DATEDIF Formula
excel
```
=DATEDIF(StartDate,EndDate,"D")
```
Use: Date difference
Example: Employee tenure, project duration
EDATE Formula
excel
```
=EDATE(StartDate,3)
```
Use: Add months to date
Example: Project deadlines, contract dates
WORKDAY Formula
excel
```
=WORKDAY(StartDate,10)
```
Use: Business days calculation
Example: Project timelines, excluding weekends

📝 TEXT FORMULAS

CONCATENATE Formula
excel
```
=CONCATENATE(A2," ",B2)
```
Use: Combine text
Example: Full names, addresses
LEFT Formula
excel
```
=LEFT(A2,3)
```
Use: Extract left characters
Example: Short codes, prefixes
RIGHT Formula
excel
```
=RIGHT(A2,4)
```
Use: Extract right characters
Example: File extensions, suffixes
MID Formula
excel
```
=MID(A2,3,5)
```
Use: Extract middle text
Example: Product codes, substrings
LEN Formula
excel
```
=LEN(A2)
```
Use: Text length
Example: Data validation, character count
TRIM Formula
excel
```
=TRIM(A2)
```
Use: Remove extra spaces
Example: Data cleaning, formatting
UPPER Formula
excel
```
=UPPER(A2)
```
Use: Convert to uppercase
Example: Standardizing text
LOWER Formula
excel
```
=LOWER(A2)
```
Use: Convert to lowercase
Example: Data normalization
PROPER Formula
excel
```
=PROPER(A2)
```
Use: Capitalize first letters
Example: Names, titles formatting

📊 STATISTICAL FORMULAS

MEDIAN Formula
excel
```
=MEDIAN(A2:A20)
```
Use: Find median value
Example: Salary distribution, performance analysis
MODE Formula
excel
```
=MODE(A2:A20)
```
Use: Find most frequent value
Example: Common issues, frequent values
STDEV Formula
excel
```
=STDEV(A2:A20)
```
Use: Standard deviation
Example: Data variability, quality control
RANK Formula
excel
```
=RANK(A2,A$2:A$20)
```
Use: Rank numbers
Example: Performance ranking, sales ranking

🔢 MATH FORMULAS

ROUND Formula
excel
```
=ROUND(A2,2)
```
Use: Round to decimals
Example: Currency, percentages
ROUNDUP Formula
excel
```
=ROUNDUP(A2,0)
```
Use: Always round up
Example: Packaging, resource allocation
ROUNDDOWN Formula
excel
```
=ROUNDDOWN(A2,0)
```
Use: Always round down
Example: Cost calculations, estimates
MOD Formula
excel
```
=MOD(A2,3)
```
Use: Remainder after division
Example: Even/odd check, cycling patterns
POWER Formula
excel
```
=POWER(A2,2)
```
Use: Exponentiation
Example: Area calculations, growth rates
SQRT Formula
excel
```
=SQRT(A2)
```
Use: Square root
Example: Statistical calculations, engineering

💰 FINANCIAL FORMULAS

PMT Formula
excel
```
=PMT(Rate/12,Term*12,-LoanAmount)
```
Use: Loan payment calculation
Example: EMI calculation, loan planning
FV Formula
excel
```
=FV(Rate/12,Term*12,-MonthlyPayment)
```
Use: Future value of investment
Example: Retirement planning, savings
PV Formula
excel
```
=PV(Rate/12,Term*12,-MonthlyPayment)
```
Use: Present value calculation
Example: Investment analysis
NPV Formula
excel
```
=NPV(Rate,CashflowRange)
```
Use: Net present value
Example: Project valuation, investment decisions

🔄 REFERENCE FORMULAS

INDEX Formula
excel
```
=INDEX(DataRange,3,2)
```
Use: Get value from position
Example: Data extraction, dynamic ranges
MATCH Formula
excel
```
=MATCH("SearchValue",SearchRange,0)
```
Use: Find position of value
Example: Combined with INDEX for powerful lookups
INDEX-MATCH Combination
excel
```
=INDEX(ReturnRange,MATCH(SearchValue,SearchRange,0))
```
Use: Flexible lookup alternative to VLOOKUP
Example: Left lookups, dynamic data retrieval
CHOOSE Formula
excel
```
=CHOOSE(3,"Low","Medium","High")
```
Use: Select from list based on index
Example: Categorization, scenario selection

✅ LOGICAL FORMULAS

AND Formula
excel
```
=AND(A2>50,B2<100)
```
Use: Multiple conditions (ALL must be TRUE)
Example: Eligibility checks, validation
OR Formula
excel
```
=OR(A2>90,B2>90)
```
Use: Multiple conditions (ANY can be TRUE)
Example: Qualification checks, options
NOT Formula
excel
```
=NOT(A2=B2)
```
Use: Reverse logical value
Example: Exclusion criteria, inverse conditions
IFERROR Formula
excel
```
=IFERROR(A2/B2,"Error")
```
Use: Handle formula errors
Example: Clean data presentation, error handling

🔍 INFORMATION FORMULAS

ISNUMBER Formula
excel
```
=ISNUMBER(A2)
```
Use: Check if value is number
Example: Data validation, type checking
ISTEXT Formula
excel
```
=ISTEXT(A2)
```
Use: Check if value is text
Example: Data type verification
ISBLANK Formula
excel
```
=ISBLANK(A2)
```
Use: Check if cell is empty
Example: Mandatory field checks, completeness
CELL Formula
excel
```
=CELL("filename",A1)
```
Use: Get cell information
Example: File path, formatting info

#ExcelFormulas #ExcelInHindi #OfficeTips #MSExcel #ExcelGuide 
#DataAnalysis #ExcelTips #ComputerKnowledge #OfficeWork #ExcelTutorial

#ExcelFormulas #ExcelInHindi #OfficeTips #MSExcel #ExcelGuide 
#DataAnal#ExcelFormul#ExcelFormulas #ExcelInHindi #OfficeTips #MSExcel #ExcelGuide

#DataAnalysis #ExcelTips #ComputerKnowledge #OfficeWork #ExcelTutorialas #ExcelInHindi #OfficeTips #MSExcel #ExcelGuide

#DataAnalysis #ExcelTips #ComputerKnowledge #OfficeWork #ExcelTutorialExcelInHindi #OfficeTips #MSExcel #ExcelGuide

Comments