| No |
Formula |
Use |
| 1 | =SUM(A1:A10) | Add Numbers |
| 2 | =AVERAGE(A1:A10) | Average |
| 3 | =COUNT(A1:A10) | Count Cells |
| 4 | =COUNTA(A1:A10) | Count Non Blank |
| 5 | =IF(A1>50,"Pass","Fail") | Condition |
| 6 | =VLOOKUP(A2,B2:D10,2,FALSE) | Vertical Lookup |
| 7 | =HLOOKUP(A2,B2:D10,2,FALSE) | Horizontal Lookup |
| 8 | =XLOOKUP(A2,A2:A10,B2:B10) | Advanced Lookup |
| 9 | =INDEX(A1:B10,2,2) | Get Value |
| 10 | =MATCH(A2,A2:A10,0) | Position |
| 11 | =INDEX(B2:B10,MATCH(A2,A2:A10,0)) | Index Match |
| 12 | =LEFT(A1,4) | Left Text |
| 13 | =RIGHT(A1,3) | Right Text |
| 14 | =MID(A1,2,4) | Middle Text |
| 15 | =LEN(A1) | Length |
| 16 | =TRIM(A1) | Remove Spaces |
| 17 | =UPPER(A1) | Uppercase |
| 18 | =LOWER(A1) | Lowercase |
| 19 | =PROPER(A1) | Capitalize |
| 20 | =CONCAT(A1,B1) | Join Text |
| 21 | =TODAY() | Current Date |
| 22 | =NOW() | Date & Time |
| 23 | =ROUND(A1,2) | Round |
| 24 | =ROUNDUP(A1,2) | Round Up |
| 25 | =ROUNDDOWN(A1,2) | Round Down |
| 26 | =MAX(A1:A10) | Maximum |
| 27 | =MIN(A1:A10) | Minimum |
| 28 | =SUMIF(A1:A10,">50") | Conditional Sum |
| 29 | =COUNTIF(A1:A10,">50") | Conditional Count |
| 30 | =AVERAGEIF(A1:A10,">50") | Conditional Average |
| 31 | =SUMIFS(A1:A10,B1:B10,">50") | Multiple Sum |
| 32 | =COUNTIFS(A1:A10,">50") | Multiple Count |
| 33 | =IFERROR(A1/B1,0) | Error Handling |
| 34 | =ISNUMBER(A1) | Check Number |
| 35 | =ISTEXT(A1) | Check Text |
| 36 | =PMT(10%/12,60,-100000) | Loan EMI |
| 37 | =FV(10%/12,60,-1000) | Future Value |
| 38 | =NPV(10%,A1:A5) | Net Present Value |
| 39 | =IRR(A1:A5) | Return Rate |
| 40 | =TEXT(A1,"dd-mm-yyyy") | Date Format |
| 41 | =DAY(A1) | Day |
| 42 | =MONTH(A1) | Month |
| 43 | =YEAR(A1) | Year |
| 44 | =EDATE(A1,1) | Add Month |
| 45 | =NETWORKDAYS(A1,B1) | Working Days |
| 46 | =WEEKDAY(A1) | Weekday |
| 47 | =FILTER(A1:B10,A1:A10>50) | Filter Data |
| 48 | =UNIQUE(A1:A10) | Unique Values |
| 49 | =SORT(A1:A10) | Sort |
| 50 | =TRANSPOSE(A1:A5) | Transpose |
| 51 | =OFFSET(A1,1,1) | Shift Cell |
| 52 | =INDIRECT("A"&B1) | Dynamic Ref |
| 53 | =CHOOSE(2,A1,B1,C1) | Choose Value |
| 54 | =SUBTOTAL(9,A1:A10) | Filtered Sum |
| 55 | =AGGREGATE(9,5,A1:A10) | Advanced Total |
| 56 | =RAND() | Random |
| 57 | =RANDBETWEEN(1,100) | Random Between |
| 58 | =SMALL(A1:A10,2) | 2nd Smallest |
| 59 | =LARGE(A1:A10,2) | 2nd Largest |
| 60 | =REPLACE(A1,1,3,"Hi") | Replace |
| 61 | =SEARCH("a",A1) | Search |
| 62 | =FIND("a",A1) | Find |
| 63 | =EXACT(A1,B1) | Exact Match |
| 64 | =VALUE(A1) | Text to Number |
| 65 | =TEXTJOIN(",",TRUE,A1:A5) | Join Range |
| 66 | =IFS(A1>90,"A",A1>60,"B") | Multi IF |
| 67 | =SWITCH(A1,1,"One",2,"Two") | Switch |
| 68 | =CEILING(A1,5) | Round Up |
| 69 | =FLOOR(A1,5) | Round Down |
| 70 | =MOD(A1,2) | Remainder |
| 71 | =POWER(A1,2) | Power |
| 72 | =SQRT(A1) | Square Root |
| 73 | =ABS(A1) | Absolute |
| 74 | =LOG(A1) | Log |
| 75 | =EXP(A1) | Exponential |
| 76 | =SUMPRODUCT(A1:A5,B1:B5) | Multiply Sum |
| 77 | =COUNTBLANK(A1:A10) | Blank Count |
| 78 | =NA() | Error Value |
| 79 | =N(A1) | Convert |
| 80 | =T(A1) | Text Only |
| 81 | =DATE(2025,2,20) | Create Date |
| 82 | =TIME(10,30,0) | Create Time |
| 83 | =DATEDIF(A1,B1,"Y") | Year Diff |
| 84 | =LEN(TRIM(A1)) | Clean Length |
| 85 | =IFNA(A1/B1,0) | NA Error |
| 86 | =SUM(A:A) | Full Column |
| 87 | =COUNT(A:A) | Full Count |
| 88 | =AVERAGE(A:A) | Full Avg |
| 89 | =MAX(A:A) | Full Max |
| 90 | =MIN(A:A) | Full Min |
| 91 | =LOOKUP(A1,A1:A10,B1:B10) | Lookup |
| 92 | =DAYS(B1,A1) | Total Days |
| 93 | =HOUR(A1) | Hour |
| 94 | =MINUTE(A1) | Minute |
| 95 | =SECOND(A1) | Second |
| 96 | =UPPER(TRIM(A1)) | Clean Caps |
| 97 | =LOWER(TRIM(A1)) | Clean Lower |
| 98 | =PROPER(TRIM(A1)) | Clean Proper |
| 99 | =REPT(A1,3) | Repeat Text |
| 100 | =CONCATENATE(A1," ",B1) | Join Text |
