Advertisement
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
ExcelCalcs The ExcelCalcs Website User Suggestions/Ideas box
Re: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: Re:logic statements and equations
#585
dakk01 ()
User Offline Click here to see the profile of this user
logic statements and equations 1 Year, 2 Months 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 ()
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 1 Year, 2 Months ago Karma: 471  
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  
 
Training, engineering consultancy and finite element analysis.
  The administrator has disabled public write access.
#626
BridgerJeff ()
User Offline Click here to see the profile of this user
Re:logic statements and equations 1 Year, 2 Months 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