also.....
What if I wanted a diffferent value to appear, other than a five if they selected a specif option form teh drop down menu?
Example: B6 list=Math, English,Other, blank
In C6 I have =IF(B2="","",5) which generates a 5 if the cell has something selected. How can I have it generate nothing if the selection is Other.
Is this possible?