AwolbertBrass ContributorFeb 25, 2021Excel Formula Adjustment 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 t...Show MoreTemplate for 2021 Quotes.xls70 KB
JMB17Bronze ContributorFeb 25, 2021Try:I5 =IF(($E5>0)*($E5<=5)*($D5=0),$H5*(1-$I$2),0)J5 =IF(($E5>5)*($D5=0),$H5*(1-$J$2),0)K5 =(D5+(D5=0)*MAX(I5,J5))*E5
