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.

There are plenty of ways to skin that cat. Just off the top of my head...

* You could have to separate sets of data and equations on the same sheet.
* You could have a drop down box to select which output which would code to modify the inputs/equations appropriately.
* You could separate the data entry from the display cells.

Can you show some examples? I have only limited knowledge of Excel, not above any ordinary user. Your methods are a bit advanced for me to repeat without assistance.