Greetings all!



Some types of calcualtions do exist that allow different input and part of calculations therefore follow different branches for some time. A good example is the calculation of the spur gear pair, which has two options: user can input either distance between axes, and then correction coefficients will be calculated, or vise versa - he can input correction coefficients and then distance between axes will be calculated. The resrt of the calculation will be the same.

Is it possible to make this calculation on the single Excel sheet? So that user could choose which of the scenario he is going to follow, and Excel would switch calculation between two sets of formulas.