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”)
=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”,” “)
