Formula:
=CHOOSE(IF(B4="bew",1,2),IF($B65<=$J$79,IF(AND(C65<$C$79,C65>$F$79),C65,IF(ROW()-ROW($C$86)=1,0,"")),
IF($B65<=$D$80,IF(AND(C65<((($C$80-$C$79)/($D$80-$J$79))*($B65-$J$79)+$C$79),C65>((($F$80-$F$79)/($D$80-$J$79))*($B65-$J$79)+$F$79)),C65,""),
IF($B65<=$D$81,IF(AND(C65<((($C$81-$C$80)/($D$81-$D$80))*($B65-$D$80)+$C$80),C65>((($F$81-$F$80)/($D$81-$D$80))*($B65-$D$80)+$F$80)),C65,""),
IF($B65<=$D$82,IF(AND(C65<((($C$82-$C$81)/($D$82-$D$81))*($B65-$D$81)+$C$81),C65>((($F$82-$F$81)/($D$82-$D$81))*($B65-$D$81)+$F$81)),C65,""),
IF($B65<=$K$79,IF(AND(C65<$J$79,C65>$M$79),C65,IF(ROW()-ROW($C$86)=1,0,""))))))),IF($B65<=$K$79,IF(AND(C65<$J$79,C65>$M$79),C65,IF(ROW()-ROW($C$86)=1,0,"")),
IF($B65<=$K$80,IF(AND(C65<((($J$80-$J$79)/($K$80-$K$79))*($B65-$K$79)+$J$79),C65>((($M$80-$M$79)/($K$80-$K$79))*($B65-$K$79)+$M$79)),C65,""),
IF($B65<=$K$81,IF(AND(C65<((($J$81-$J$80)/($K$81-$K$80))*($B65-$K$80)+$J$80),C65>((($M$81-$M$80)/($K$81-$K$80))*($B65-$K$80)+$M$80)),C65,""),
IF($B65<=$K$82,IF(AND(C65<((($J$82-$J$81)/($K$82-$K$81))*($B65-$K$81)+$J$81),C65>((($M$82-$M$81)/($K$82-$K$81))*($B65-$K$81)+$M$81)),C65,""))))))
Bookmarks