Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Excel conditional statements
Name: jdennis789 Date: February 27, 2005 at 13:05:12 Pacific OS: Windows XP CPU/Ram: AMD XP 2000+ / 256 SDRam
Comment:
I wanted to use a drop down list that consisted of 'Yes' and 'No'. Whenever someone chooses 'Yes', I want all of the other 3 boxes to turn to 'No'...anyone got any ideas? Thanks in advance!
Name: Michael J (by mjdamato) Date: February 27, 2005 at 21:21:52 Pacific
Reply:
This is a hack, but it should work. If you are using a range of cells for the contents of your select list:
Have 2 cells for Yes/No on the first option Have 2 different cells for the Yes/No option of the other three
But, for the Yes option for the other three make it an if then (if the value of select 1 = No, then value = no, else = yes)
Example: =if(B1='No','No','Yes') Where B! is the cell of the first select list
Michael J
0
Response Number 2
Name: jdennis789 Date: March 2, 2005 at 18:51:39 Pacific
Reply:
This didn't work. I have cells G30, J30, M30, and P30. Whenever I click choose "Yes" from the G30, I want the other 3 to turn to "No" or if I choose M30 to be "Yes", I want the other 3 to turn to "No". Thanks for the try though.
Summary: Sulfurik, Great to hear that that little piece of code helped you out. I think it'd be really cool though if you went on and developed the same thing in ifstream. I would if I wasn't so busy develop...
Summary: I have an html form that is processed and sent to an email address using cgi coded in perl. There are many fields in this program, my question is: Rather than using a bunch of single conditional stat...
Summary: My instructor said it's basically nested loops with conditional statement to check for whether no duplicate numbers are used and comparison statement to get the largest value..... He said it can be d...
0 
