Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs The ExcelCalcs Website User Suggestions/Ideas box
logic statements and equations (1 viewing) (1) Guest
Please post any suggestions or ideas that you think the ExcelCalcs team should consider.
Go to bottom Post Reply Favoured: 0
TOPIC: logic statements and equations
#585
dakk01 (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
logic statements and equations 10 Months, 1 Week ago Karma: 1  
First off, great site, its very useful!
I was wondering if its possible to display the equations as a single equation if I were to use logical statements. For example, if I use the generic formula

=if(A1="yes",B1*C1,D1*E1)

and click the 'show equation' button in the next cell, the output would be kind of messy. Is there any way to program the equation output such that the correct equation shows up based on the logic statements inputted?

Thanks, and keep up the good work.
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#589
JohnDoyle (Admin)
Admin
Posts: 384
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:logic statements and equations 10 Months ago Karma: 468  
mmm .... I don't think so. XLC is always going to try to display the cell formula. So as it stands XLC tries to make an equation from the IF statement.
 
Report to moderator   Logged Logged  
 
Talk to me about training.
Talk to me about engineering consultancy work and finite element analysis.
  The administrator has disabled public write access.
#626
BridgerJeff (User)
Fresh Boarder
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:logic statements and equations 9 Months, 3 Weeks ago Karma: 6  
i strongly support the development of this feature
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop