Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-06-2014, 12:17 AM
Scaffold Scaffold is offline Branching calculations in Excel Windows 7 64bit Branching calculations in Excel Office 2013
Advanced Beginner
Branching calculations in Excel
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default Branching calculations in Excel

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.
Reply With Quote
  #2  
Old 09-06-2014, 08:14 AM
gebobs gebobs is offline Branching calculations in Excel Windows 7 64bit Branching calculations in Excel Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

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.
Reply With Quote
  #3  
Old 09-06-2014, 08:34 AM
Scaffold Scaffold is offline Branching calculations in Excel Windows 7 64bit Branching calculations in Excel Office 2013
Advanced Beginner
Branching calculations in Excel
 
Join Date: Oct 2009
Location: Moscow, Russia
Posts: 36
Scaffold is on a distinguished road
Default

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.
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Branching calculations in Excel Tiered Fee Calculations lynchbro Excel 5 07-17-2014 11:01 AM
Branching calculations in Excel Table Calculations, VBA SuzeG Word VBA 7 12-15-2013 07:12 PM
Branching calculations in Excel Mortgage repayment calculations BritBiker2 Excel 2 10-14-2013 10:55 PM
How to do Calculations In a Text Box? SteveF Word 4 09-27-2013 08:34 AM
Branching calculations in Excel Can I do calculations with times? cubsfan_1 Excel 1 01-14-2010 06:55 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:33 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft