| S/N | FORMULA | FORMULA FOR |
| 1 | =SUM(RANGE) | TOTAL |
| 2 | =COUNT(RANGE) | COUNT |
| 3 | =MAX(RANGE) | MAXIMIZE |
| 4 | =MIN(RANGE) | MINIMIZE |
| 5 | =TODAY() | INSERT CURRENT DATE |
| 6 | =NOW() | INSERT CURRENT DATE AND CURRENT TIME |
| 7 | =AVERAGE(RANGE) | FIND THE AVERAGE |
| 8 | =COUNTIF(RANGE,”WHAT YOU FIND”) | COUNT THE COLUMN AND ROW VALUSES |
| 9 | =SUMIF(RANGE,”WHAT YOU FIND”,RANGE) | SUM OF THE SELECTED ITEM OR VALUE |
| 10 | =IF(P2>85,”A”,IF(P2>65,”B”,IF(P2>45,”C”,IF(P2>33,”D”,IF(P2<33,”FAIL”,))))) | GRADE |
| 11 | =DATEDIF(DATE1,DATE2,”Y”) | FIND THE YEAR |
| 12 | =DATEDIF(DATE1,DATE2,”YM”) | FIND THE MONTH |
| 13 | =DATEDIF(DATE1,DATE2,”MD”) | FIND THE DAY |
| 14 | =PRINCIPAL*RATE*TIME/100 | SIMPLE INTEREST |
| 15 | =TOTAL MARKS/MAXIMUM MARKS*100 | PERCENTAGE |
| 16 | =ROUND(SELECT VALUE,0) | ROUND FIGURE |
| 17 | =EXACT(TEXT1, TEXT2) | MATCH TWO COLUMN |
| 18 | =LEN(SELECT TEXT) | COUNT CHARACTERS |
| 19 | =TRIM(SELECT TEXT) | REMOVE EXTRA SPACE |
| 20 | =UPPER(SELECT TEXT) | CHANGE TEXT TO UPPER CASE |
| 21 | =LOWER(SELECT TEXT) | CHANGE TEXT TO LOWER CASE |
| 22 | =SUBTOTAL(9,RANGE) | TOTAL WITH FILTER |
| 23 | =SUBTOTAL(3,$B$2:B2) | COUNT WITH FILTER |
| 24 | =CONCATENATE(TEXT1, “SPACE”,TEXT2) | MARGE TWO TEXT INTO 1 |
| 25 | =VLOOKUP(LOOKUP VALUE, TABLE ARRAY, COLUMN INDEX NUMBER, TRUE OR FALSE) | FIND VALUE VERTICALLY |
| 25 | =HLOOKUP(LOOKUP VALUE, TABLE ARRAY, ROW INDEX NUMBER, TRUE OR FALSE) | FIND VALUE HORIZONTALLY |
| 26 | =CELL(“FILENAME”) | KNOW WHERE SAVE OUR FILE |
145