Microsoft Excel Formulas Cheat Sheet: The Ultimate Guide
Microsoft Excel Formulas Cheat Sheet: The Ultimate Guide
Basic Mathematics Formulars
|
Description |
Formula |
Example |
|
Total/Sum for set of cells |
=SUM(cell range) |
=SUM(K8:K18) |
|
Sum of Individual Items / Cells |
= Value1 + Value2 |
=K3 + K5 |
|
Subtract |
=Value1 – Value2 |
=K3 – K5 |
|
Multiply |
=Value1 * Value 2 |
=K3 * K5 |
|
Divide |
=Value1 / Value2 |
=K3 / K5 |
|
Exponents |
=Value1 ^ Value2 |
=K3 ^ K5 |
|
Median |
=MEDIAN(cell range) |
=MEDIAN(K3:K10) |
|
Max |
=MAX(cell range) |
=MAX(K3:K10) |
|
Min |
=MIN(cell range) |
=MIN(K3:K10) |
|
Average |
=AVERAGE(cell range) |
=AVERAGE(K3:K10) |
Other Formatting Techniques
|
Function |
Formula |
Example |
|
Change cell to Upper Case |
=UPPER(cell) |
=UPPER(K7) |
|
Change cell to Lower Case |
=LOWER(cell) |
=LOWER(K9) |
|
Change cell to Proper Case |
=PROPER(cell) |
= PROPER(K10) |
Conditional Statements
|
Function |
Formula |
Example |
|
If statement |
=IF(logical test, “result if the test answer is true”,“result if the test answer is false”) |
=if(B2>69, “Pass”, “Fail” |
|
Exact |
=EXACT(Value1, Value2) |
=EXACT(B2, C2) |
- Master Any Job Interview with These Expert Tips
- How to Professional Ask About a Job Opportunity
- Microsoft Excel Formulas Cheat Sheet: The Ultimate Guide
- Resume Skills That Get You Hired Fast (Proven List)
- Best Websites to Find Remote Work Opportunities Right Now
Other Blog Posts
- Cover letter for a Marketing Officer position
- Application for Accounts Executive Position
- Best CV format to Apply for Jobs in UK
- Cover Letter to Apply for All Jobs
- Cover letter for an Office Administrator position
Other CVs & Cover Letters
- Study in the USA: Denison University Scholarships + Free Application Guide
- Apply Now: Innovation & Technology Scholarships for 2025
- How to Apply for the Deloitte Scholarship 2025: Full Guide
- Scholarship to Study at the University of South Wales
- Apply for the LUG-KGL Foundation Scholarship – Fully Funded Opportunity