Scribd
Upload
5 views2 pages

? Basic Excel Formulas

The document provides a comprehensive overview of various Excel functions categorized into Basic Formulas, Text Functions, Logical Functions, Lookup & Reference, Date & Time, Math Functions, and Financial functions. Each category includes specific formulas with brief descriptions of their functionalities. This serves as a quick reference guide for users to utilize Excel effectively.

Uploaded by

rimshaliaqatali000
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
5 views2 pages

? Basic Excel Formulas

The document provides a comprehensive overview of various Excel functions categorized into Basic Formulas, Text Functions, Logical Functions, Lookup & Reference, Date & Time, Math Functions, and Financial functions. Each category includes specific formulas with brief descriptions of their functionalities. This serves as a quick reference guide for users to utilize Excel effectively.

Uploaded by

rimshaliaqatali000
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

📌 Basic Excel Formulas

1. =SUM(A1:A10) → Numbers ka sum karega.


2. =AVERAGE(A1:A10) → Average nikalne ke liye.
3. =MIN(A1:A10) → Sabse chhota number.
4. =MAX(A1:A10) → Sabse bada number.
5. =COUNT(A1:A10) → Sirf numbers ki ginti.
6. =COUNTA(A1:A10) → Non-empty cells count karega.

📌 Text Functions
1. =CONCATENATE(A1," ",B1) → Text ko jodna.
(Naya function: =CONCAT(A1,B1))
2. =LEFT(A1,5) → Text ke left side ke 5 letters.
3. =RIGHT(A1,5) → Right side ke 5 letters.
4. =MID(A1,2,4) → Text ke beech se 4 letters (2nd position se).
5. =LEN(A1) → Text ki length.
6. =TRIM(A1) → Extra spaces hata dega.
7. =PROPER(A1) → Har word ka pehla letter capital.
8. =UPPER(A1) → Sab text capital.
9. =LOWER(A1) → Sab text small.

📌 Logical Functions
1. =IF(A1>50,"Pass","Fail")
2. =AND(A1>10,B1<20)
3. =OR(A1>10,B1<20)
4. =NOT(A1>10)

📌 Lookup & Reference


1. =VLOOKUP(lookup_value, table_array, col_index, FALSE)
2. =HLOOKUP(lookup_value, table_array, row_index, FALSE)
3. =XLOOKUP(lookup_value, lookup_array, return_array) (New Excel 365 me)
4. =INDEX(A1:C10,2,3) → Row 2 aur Column 3 ka value.
5. =MATCH(50,A1:A10,0) → 50 ka position dega.
📌 Date & Time
1. =TODAY() → Current date.
2. =NOW() → Current date & time.
3. =DAY(A1) → Date ka din nikalta hai.
4. =MONTH(A1) → Month nikalta hai.
5. =YEAR(A1) → Year nikalta hai.
6. =WEEKDAY(A1) → Week ka din (1=Sunday).
7. =DATEDIF(A1,B1,"Y") → Do dates ke beech years ka difference.

📌 Math Functions
1. =ROUND(A1,2) → 2 decimal tak round karega.
2. =ROUNDUP(A1,0) → Always upar round karega.
3. =ROUNDDOWN(A1,0) → Always neeche round karega.
4. =POWER(A1,2) → Square karega.
5. =SQRT(A1) → Square root.
6. =ABS(A1) → Absolute value.
7. =MOD(A1,2) → Remainder nikalta hai.

📌 Financial
1. =PMT(rate, nper, pv) → Loan ka payment.
2. =FV(rate, nper, pmt) → Future value.
3. =NPV(rate, values) → Net Present Value.

You might also like