*Essential Excel Formulas* 📊✨ 1️⃣ *SUM* Adds numbers in a range. Example: `=SUM(A1:A10)` 2️⃣ *AVERAGE* Calculates the mean. Example: `=AVERAGE(B1:B10)` 3️⃣ *COUNT* Counts numeric entries. Example: `=COUNT(C1:C10)` 4️⃣ *COUNTA* Counts non-empty cells (numbers, text). Example: `=COUNTA(D1:D10)` 5️⃣ *IF* Conditional logic. Example: `=IF(A1>10, "Yes", "No")` 6️⃣ *AND / OR* Combine conditions inside IF. Example: `=IF(AND(A1>10, B1<5), "OK", "No")` 7️⃣ *VLOOKUP* Lookup vertical tables. Example: `=VLOOKUP(101, A2:D10, 3, FALSE)` 8️⃣ *HLOOKUP* Lookup horizontal tables. Example: `=HLOOKUP("Q1", A1:D4, 3, FALSE)` 9️⃣ *INDEX & MATCH* Powerful lookup combo (flexible & efficient). Example: `=INDEX(B2:B10, MATCH(101, A2:A10, 0))` 🔟 *CONCATENATE / TEXTJOIN* Join text strings. Example: `=CONCATENATE(A1, " ", B1)` or `=TEXTJOIN(" ", TRUE, A1:B1)` 1️⃣1️⃣ *LEFT / RIGHT / MID* Extract parts of text. Example: `=LEFT(A1, 4)`, `=RIGHT(A1, 3)`, `=MID(A1, 2, 5)` 1️⃣2️⃣ *LEN* Get text length. Example: `=LEN(A1)` 1️⃣3️⃣ *TRIM* Remove extra spaces. Example: `=TRIM(A1)` 1️⃣4️⃣ *NOW() / TODAY()* Current date/time or just date. Example: `=NOW()`, `=TODAY()` 1️⃣5️⃣ *ROUND / ROUNDUP / ROUNDDOWN* Round numbers precisely. Example: `=ROUND(A1, 2)` 1️⃣6️⃣ *IFERROR* Handle errors gracefully. Example: `=IFERROR(A1/B1, "Error")` 1️⃣7️⃣ *PMT* Loan payment calculator. Example: `=PMT(5%/12, 60, -10000)` 1️⃣8️⃣ *TEXT* Format numbers/dates as text. Example: `=TEXT(A1, "dd-mmm-yyyy")` 💬 *React ❤️ for more*📊