IF formula

If cell is blank then result is 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(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”,” “)

Leave a Reply

Your email address will not be published. Required fields are marked *