I think that I am going about this wrong.
I have the length of a needed part (balance rod) in cell L127=rounddown((L108-2),0). We have switched vendors and now are only using even length balance rods.
L108 contains the product height divided by 2.
L127 (balance length) can never be less...