Hello everyone - I was hoping to get a little help with this formula (in COL BE2), please:
=IF(AND($AP2="x",$AW2="L",I3>BC2),J3-AY2,IF(AND($AP2="x",$AW2="S",H3<BC2),AY2-J3,IF(AND($AP2="x",$AW2="L",I3<=BC2),BC2-AY2,IF(AND($AP2="x",$AW2="S",H3>=BC2),AY2-BC2,""))))
It does what it is supposed...