2014-11-26 · For example, your logical test can be expressed as or B1="sold", B1<12/1/2014, B1=10 or B1>10. value_if_true (optional) - the value to return when the logical test evaluates to TRUE, i.e. if the condition is met. For example, the following formula will return the text "Good" if a value in cell B1 is greater than 10: =IF(B1>10, "Good")

4596