I need help with an "IF" formula. I received tips from this community to create formulas in the attached spreadsheet but I need one more contingency formula. I am offering quantity discounts in two tiers and the formulas work well but I cannot offer the quantity discounts on custom product. Therefore if a Custom Quote number appears in column D, there will be no discount offered on Column H (so I and J would be blank, and the extension will be straightforward. See example line 10.
Is there a formula that would disallow a discount in Columns I and J IF there is a custom quote in D? Then could the extension column be adjusted as well to merely create a sum of the quantity and cost each? Thank you so much to anyone who can help.
