I'm having trouble applying two separate discounts to an order using Excel. For example, if the order is greater than $50, the customer receives a discount of 10%. Also if the customer has a discount ticket, they receive a separate discount of 7%. The discounts are not compounded; the 10% discount is applied first, and then the 7% discount. I'm trying to apply the discounts to the ORIGINAL amount.
Solved by B. F. in 24 mins