active
Joined: Mon, Mar 17, 2008
19 Posts No Rating |
I need some help understanding conditional statements. My desire is to have a parameter that will return the integer number of certain other parameters that are checked as 'yes'. In other words, this summing parameters will return '3' when I have three of the five yes/no parameters checked as 'yes', then of course, when only one is checked as ‘yes’ it will return ‘1’. Any ideas? Thank you for any help with this. AVSteve
|
active
Joined: Mon, Mar 17, 2008
19 Posts No Rating |
I just solved my own problem, with the help of google of course. My example: Up Throw = Yes Down throw = Yes Left Throw = Yes Right Throw = Yes THEN Throw = 4 = (if(Up Throw, 1, 0)) + (if(Down Throw, 1, 0)) + (if(Right Throw, 1, 0)) + (if(Left Throw, 1, 0)) AND Up Throw = No Down throw = Yes Left Throw = Yes Right Throw = Yes THEN Throw = 3 = (if(Up Throw, 1, 0))+ (if(Down Throw, 1, 0)) + (if(Right Throw, 1, 0)) + (if(Left Throw, 1, 0)) AND SO ON…. I hope this will help someone! Edited on: Fri, May 9, 2008 at 3:44:49 PM
Edited on: Fri, May 9, 2008 at 3:46:14 PM
|
active
Joined: Tue, Nov 7, 2006
456 Posts
|
Hi, Thanks for sharing your problem and solution. You should do that more often. Mhans
-----------------------------------
Motto: "No Post left behind" |