To demonstrate the concept, let's check the item names in column A and return "Fruit" for Apple or Orange and "Vegetable" for Tomato or Cucumber: In situations when you want to test a few sets of OR criteria and return different values depending on the results of those tests, write an individual IF formula for each set of "this OR that" criteria, and nest those IF's into each other. =IF(OR(EXACT(A2, "AA-1"), EXACT(A2, "BB-1")), "x", "")Īs the result, only two orders IDs where the letters are all capital are marked with "x" similar IDs such as "aa-1" or "Bb-1" are not flagged:įormula 4. In this example, let's find and mark the order IDs "AA-1" and "BB-1": IF(OR(EXACT( cell," condition1"), EXACT( cell," condition2")), value_if_true, value_if_false) In this case, perform each individual logical test inside the EXACT function and nest those functions into the OR statement. However, your data might be case-sensitive and so you'd want to run case-sensitive OR tests. The screenshot below shows both formulas in action:Īs already mentioned, the Excel OR function is case-insensitive by nature.
So, you use the OR function to check both conditions, and if the result is TRUE, decrease the total amount by 10% (B2*C2*0.9), otherwise return the full price (B2*C2):Īdditionally, you could use the below formula to explicitly indicate the discounted orders:
In our case, "delivered", "Delivered", and "DELIVERED", are all deemed the same word.
Please pay attention that an IF OR formula in Excel does not differentiate between lowercase and uppercase characters because the OR function is case-insensitive.