MS Excel

Excel Functions

Fillup cell count 
=COUNTA(D4:D7)

Merge multiple columns into a single column
=CONCATENATE(Cell," ",Cell)

Blank cell count 
=COUNTBLANK(D4:D7)
If cell is blank then result is 200  =IF(ISBLANK(A1),””,200) =IF(B1>10, TRUE, FALSE) or=IF(B1>10, TRUE) =IF(B2 = “mahbub”,”Correct”,” “) If A2 cell range is 5 then result is OK =IF(A2<=5, “OK”, “”) If C2 cell range delivered/other range then result is Yes/No =IF(C2=”delivered”, “No”, “Yes”) IF formula for text values with partial match  =IF(ISNUMBER(SEARCH(“deliv”,C2)), “No”, “Yes”) IF formulas for dates with DATEVALUE function  =IF(C2<datevalue(“11 19="" 2014”),="" “completed”,="" “coming="" soon”)<br=""></datevalue(“11>=IF(A2=”D”,”55″,IF(A2=”N”,”50″)) =IF(OR(ISBLANK(J2),ISBLANK(M2),ISBLANK(R2),ISBLANK(AA2),ISBLANK(AB2)), “Not Complete”, “Complete”) =IF(B2 > 30000, B2 * 1%, 300) If cell range is mahbub then result is correct =IF(B2 = “mahbub”,”Correct”,” “) =IF(D4=”Centre In charge”,800,IF(D4=”Question Collector”,500,IF(D4=”Hall Super”,600,IF(D4=”Assistant Hall Super”,500,IF(D4=”Invigilator”,300,IF(D4=”Secretary”,500,IF(D4=”Office Assistant”,300,IF(D4=”PA to Principal”,300,IF(D4=”Special Officer”,300,IF(D4=”Accounts Officer”,150,IF(D4=”Department MLSS”,50,IF(D4=”Office MLSS”,70,IF(D4=”Driver”,150,IF(D4=”Technician”,100,IF(D4=”Computer Operator”,100)))))))))))))))

Leave a Reply

Your email address will not be published.