Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
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 Favoured: 0
TOPIC: logic statements and equations
#585
dakk01 (User)
Egg (Fresh Boarder)
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
logic statements and equations 10 Years, 4 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.
 
Logged Logged  
  The administrator has disabled public write access.
#589
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1747
graph
User Offline 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 Years, 4 Months ago Karma: 493  
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.
 
Logged Logged  
 
  The administrator has disabled public write access.
#626
BridgerJeff (User)
Tadpole with legs (Senior Boarder)
Posts: 8
graphgraph
User Offline Click here to see the profile of this user
Re:logic statements and equations 10 Years, 3 Months ago Karma: 6  
i strongly support the development of this feature
 
Logged Logged  
  The administrator has disabled public write access.
Go to top
We have 10 guests and 35 members online
Contact Us
post/emailEmail (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.

 

 

Google Analytics Alternative