Basic Of Computer Computer Education Computer Notes VS Computer Education

Excel Useful Formulas

S/NFORMULAFORMULA 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/100SIMPLE INTEREST
15=TOTAL MARKS/MAXIMUM MARKS*100PERCENTAGE
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
Spread the love

Leave a Reply

Your email address will not be published.