It is used if any of 2 or more conditions fulfilled,there is separate value
and
if not fulfilled,there is separate value
=if(or(Condition1,Condition 2),Yes value,No Value)
Example 1
Download Excel File And Try
Example 2
Example 3