Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula does not work with drop down box
Hello I n column C12 I have a formula =IF (B12="Full Time ","100%
benefits",IF(B12="Part Time","50% Benefits","Not Eligible")) If I type Full Time or Part Time in cell B12 the formula works. When I added a drop down list to column B12 the formula does not work. How do I make this work? Many thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
format a drop-down box from a range of cell from another work... | Excel Worksheet Functions | |||
Help please simple drop and drag I can't make work | Excel Worksheet Functions | |||
How do you work with drop down list to show a name, diff payment? | Excel Worksheet Functions | |||
A user says he can't get my drop down list to work in Excel. | Excel Discussion (Misc queries) | |||
drop-down list in data valadation does not work | Excel Discussion (Misc queries) |