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: ![]() Unit Price in C2 is greater than or equal to $5.in B2 is greater than or equal to 10, or.multiplied by Unit price) and you want to apply the 10% discount if either of these conditions is met: Say, you calculate the total amount for an order ( Qty. Looking for a formula that can do something more complex than return a predefined text? Just nest another function or arithmetic equation in the value_if_true and/or value_if_false arguments of IF. If a cell is this OR that, then calculate The task can be accomplished with the following IF OR function: ![]() ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |