Is it possible to control 2 input for a similar output?

[badbadtzmaru]

Just for simple understanding,

I have 2 forumla, a+b=c and d/c=e, 'a', 'b' and 'd' are to be key in while 'c' can either be key in or be found using the 1st formula

How do i control if 'c' is keyed, just use 2nd formule else use the 1st forumula

[tbob]

Do you want to make the choice between a derived C and a keyed in C available by user action, like a switch?  If so, use a case structure.  Wire the switch to the case selector.  In True case, put in formula a+b and wire output to case edge.  In False case, put in a dialog box to capture user input, and wire the output to the case edge, same terminal as True case.  C will be whatever comes out of the case edge terminal.  The switch will dictate which method you use to get C.

[RTSLVU]

There are several ways to do this.

Right off the top of my head simply use a boolean control to select if C is user input.

If you want to make it automagic use a string control and if C is not a number (or empty) use the built in C

Message Edited by RTSLVU on 05-13-2010 12:41 PM

[badbadtzmaru]

Nice thanks. Just tried and it works. But is there any way i can do without the switch because in my case, there is more then 2 formulas. I don't really want the user to see too many switch

[MikeS81]

Hi badbadtzmaru,

you don't really need a switch, you can make this decision from other user inputs.

Mike

[badbadtzmaru]

I think i get it now.

Thank for all the help