Drop Down Box or Check Box
Posted by Jim Reece on December 03, 1999 10:54 AM
I have a spreadsheet with questions in column A. In column B, I want to put a dropdown box with Select, Yes and No as the options (or simply a check box). Then in column C, I want to run an "IF" statement so that if the answer in Column B is No one result is shown and if the answer selected in column B is Yes another answer is shown. I know how to write the "IF" statement (see below), but I don't know how to make the dropdown box or check box so that it pops the result into column B. Here is my IF statement: =IF (B1=Yes,"OSHA Class I and II Asbestos Worker Certification - (Initial and Annual Refresher)","No Training Required"). Any help you can provide on making the dropdown menu or check box work with this is appreciated.