Forum Discussion
Excel Formula
My spreadsheet has quantities and prices. I have just introduced two columns for quantity discounts for 5 and under and over 5. I already have a price column EACH and then an extension formula based o...
I didn't catch you'd like to show discounted price or only discount. If the first
=IF( ($E5<=5)*($E5>0),$H5*(1-$I$2),0)
and
=IF( $E5>5,$H5*(1-$J$2),0)
and
=MAX(I5,J5)
SergeiBaklan I think I almost have it figured out. Actually I just changed the extension to be
=MAX(I5,J5)*E5 so I sum the quantity of the discounted price
Why does the formula for I column change the font color? and not stay in the $ format?
Sorry, I don't know - in my copy of the file there are no format changes.