Some tips for using IF condition

Here are some tips for using IF Condition in Excel

For not equal condition use

If (condition A <> 0, "Yes","No")

using multiple conditions using IF

If(And(Condition A <>0, condition B>1000), "Yes", "No")

.....here both the conditions should be met for YES.... the number should not be equal to '0' and also it should be greater than 1000

If (or(condition A <> 0, condition B >1000),"Yes","No")

Here ... if.. either of the condition is met then it would give "Yes" else  "No"