I have spread sheet which has a double calculation.

Fall A
The calculation is load x distance 2 x length of chain A (2000 kg x 3 MTR x 5.10 MTR) = 30594.117
Then another calculation Height x Distance 3 (5 MTR x4 MTR =20)
30594.117 divided by 20 = 1529.71 kg of tension

Fall B
The calculation is load x distance 1 x length of chain B (2000 kg x 1 MTR x 5.83 MTR) = 11661.904
Then another calculation Height x Distance 3 (5 MTR x4 MTR =20)
11661.904 divided by 20 = 1529.71 kg of tension



The result is correct however to find the maximum tension figure throughout the cycle I would have to enter various lengths heights which would take forever. How would I go about displaying the max tension within the range.