Scribd
Upload
4 views2 pages

Excel Notes Basic and Advanced Formulas

The document provides a comprehensive overview of basic, intermediate, and advanced Excel formulas. It includes functions for arithmetic operations, text manipulation, lookups, and date handling. Each formula is accompanied by a brief description of its purpose and usage.

Uploaded by

mispayogaraj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views2 pages

Excel Notes Basic and Advanced Formulas

The document provides a comprehensive overview of basic, intermediate, and advanced Excel formulas. It includes functions for arithmetic operations, text manipulation, lookups, and date handling. Each formula is accompanied by a brief description of its purpose and usage.

Uploaded by

mispayogaraj
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Excel Notes: Basic and Advanced Formulas

I. Basic Excel Formulas

SUM(A1:A5) - Adds values in A1 through A5

AVERAGE(A1:A5) - Calculates the average

MIN(A1:A5) - Returns the smallest value

MAX(A1:A5) - Returns the largest value

COUNT(A1:A5) - Counts numeric values

COUNTA(A1:A5) - Counts non-empty cells

IF(A1>50, "Pass", "Fail") - Conditional logic

NOW() - Current date and time

TODAY() - Today's date

II. Intermediate Formulas

TRIM(A1) - Removes extra spaces

CONCATENATE(A1, " ", B1) or A1 & " " & B1 - Combines text

LEFT(A1, 4) - First 4 characters

RIGHT(A1, 3) - Last 3 characters

LEN(A1) - Number of characters

PROPER(A1) - Proper case

LOWER(A1) - Lowercase

UPPER(A1) - Uppercase

ROUND(A1, 2) - Rounds to 2 decimal places

III. Advanced Formulas

VLOOKUP(101, A2:D10, 2, FALSE) - Vertical lookup

HLOOKUP("Math", A1:D4, 3, FALSE) - Horizontal lookup

INDEX(A2:C5, 2, 3) - Value at 2nd row, 3rd column


Excel Notes: Basic and Advanced Formulas

MATCH(50, A1:A10, 0) - Position of 50

IFERROR(A1/B1, "Error") - Handles errors

AND(A1>50, B1>50) - Both conditions TRUE

OR(A1>50, B1>50) - Either condition TRUE

XLOOKUP(101, A2:A10, B2:B10) - Flexible lookup

FILTER(A2:B10, B2:B10>50) - Filter by condition

IV. Date & Time Formulas

DATEDIF(A1, B1, "Y") - Difference in years

TEXT(A1, "DD/MM/YYYY") - Format date

EDATE(A1, 3) - Adds 3 months to date

You might also like