OK The formula in C4 under PRICE is
=IF(ISBLANK(B4),"",IF(A4="I",150,IF(A4="T",120,IF(A4="S",75,))))
and the formula in E4 under NEW COST is
=IF(D4="D",C4*0.8,IF(D4="SD",C4-60,""))
What I want to do is have the cost under Price disappear if there is an amount under NEW COST.
<TABLE...