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 1 Year 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.
      Topics Author Date
    thread link
logic statements and equations
dakk01 2007/07/14 00:52
    thread link
thread linkthread link Re:logic statements and equations
JohnDoyle 2007/07/16 10:22
    thread link
thread linkthread link Re:logic statements and equations
BridgerJeff 2007/07/31 00:47
Go to top Post Reply
Sponsored by MoreVision Engineering Consultantsget the latest posts directly to your desktop