Excel Formulas

Yahaan main kuch basic se lekar advanced Excel formulas ki list de raha hoon. Yeh formulas ka istemal aap apne Excel mein analysis aur data processing ke liye kar sakte hain.

1. Basic Excel Formulas

SUM: =SUM(A1:A10) - Range ka total calculate karne ke liye.
AVERAGE: =AVERAGE(A1:A10) - Range ka average nikaalne ke liye.
COUNT: =COUNT(A1:A10) - Range mein numeric values count karne ke liye.
COUNTA: =COUNTA(A1:A10) - Range mein non-empty cells count karne ke liye.
MIN: =MIN(A1:A10) - Range mein lowest value dhoondhne ke liye.
MAX: =MAX(A1:A10) - Range mein highest value dhoondhne ke liye.
ROUND: =ROUND(A1,2) - Number ko specific decimal places tak round off karne ke liye.

2. Logical Formulas

IF: =IF(A1>10, "Yes", "No") - Conditional statement apply karne ke liye.
AND: =AND(A1>10, B1<5) - Multiple conditions check karne ke liye, agar dono true hain toh true return karega.
OR: =OR(A1>10, B1<5) - Multiple conditions check karne ke liye, agar ek bhi true hai toh true return karega.
NOT: =NOT(A1=10) - Condition ka opposite return karega.

3. Lookup & Reference Formulas

VLOOKUP: =VLOOKUP("Value", Table, Column Number, FALSE) - Table mein kisi value ko dhoondhne ke liye.
HLOOKUP: =HLOOKUP("Value", Table, Row Number, FALSE) - Horizontal lookup ke liye.
INDEX: =INDEX(A1:C10, 2, 3) - Specific row aur column mein value dhoondhne ke liye.
MATCH: =MATCH("Value", A1:A10, 0) - Range mein kisi value ki position return karega.
CHOOSE: =CHOOSE(Index, Option1, Option2, Option3...) - Specific index ke basis par value select karega.

4. Text Formulas

CONCATENATE: =CONCATENATE(A1, " ", B1) - Multiple text strings ko jodne ke liye.
TEXT: =TEXT(A1, "dd-mm-yyyy") - Number ko specific format mein convert karne ke liye.
LEFT: =LEFT(A1, 5) - Text ka specific number of characters left se return karega.
RIGHT: =RIGHT(A1, 5) - Text ka specific number of characters right se return karega.
MID: =MID(A1, Start, Number of Characters) - Text ke beech se characters return karega.
LEN: =LEN(A1) - Text mein characters ki total length return karega.
SEARCH: =SEARCH("Text", A1) - Text mein kisi specific character ka position dhoondhne ke liye.

5. Date & Time Formulas

TODAY: =TODAY() - Aaj ki tareekh return karega.
NOW: =NOW() - Current date aur time return karega.
YEAR: =YEAR(A1) - Date mein se year extract karega.
MONTH: =MONTH(A1) - Date mein se month extract karega.
DAY: =DAY(A1) - Date mein se day extract karega.
DATEDIF: =DATEDIF(StartDate, EndDate, "Y") - Do dates ke beech ka difference nikaalta hai.

6. Financial Formulas

PMT: =PMT(Rate, Nper, PV) - Loan ka monthly payment calculate karne ke liye.
NPV: =NPV(Rate, Value1, Value2...) - Net Present Value calculate karne ke liye.
IRR: =IRR(Values) - Internal Rate of Return calculate karne ke liye.
FV: =FV(Rate, Nper, PMT, PV) - Future value calculate karne ke liye.

7. Advanced Formulas

ARRAYFORMULA: Google Sheets mein array formula ke liye.
SUMIF: =SUMIF(Range, Criteria, Sum Range) - Specific criteria ke basis par sum nikaalne ke liye.
COUNTIF: =COUNTIF(Range, Criteria) - Specific criteria ke basis par count karne ke liye.
SUMPRODUCT: =SUMPRODUCT(Array1, Array2) - Multiple arrays ka sum nikaalne ke liye.
IFERROR: =IFERROR(Formula, "Error Message") - Agar formula mein error hai toh custom message dikhata hai.
SUBTOTAL: =SUBTOTAL(Function Number, Range) - Range mein subtotal nikaalta hai.
INDIRECT: =INDIRECT("A1") - Cell reference ko as a text refer karta hai.

Yeh kuch common aur advanced Excel formulas hain jo analysis aur calculations mein helpful hain. Excel mein aur bhi formulas hain jo specific use cases ke liye helpful ho sakte hain.

Agar aapko kisi particular formula ka detailed example ya aur help chahiye, toh bataaye!