in reply to Re^2: Excel-Error reading in formulae value
in thread Excel-Error reading in formulae value

How does the formulae =IF(C15>C$13,IF(C15>C$12,C$8,((C15-C$13)*(C$8-C$9)/(C$12-C$13))+C$9),IF(C15<C$14,C$10,C$9-((C$13-C15)*(C$9-C$10)/(C$13-C$14)))) change with B15 when that cell doesn't appear in the formulae ?

poj