Hey all... I am working on a spreadsheet where the number 5 needs to appear in cell C2, if there text is selected from a drop down list in cell b2.
I assume I will use the IF command, but after that I am lost.
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?