MS Excel

IF formula

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

Leave a Reply

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