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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula does not work with drop down box
How are you adding a dropdown list? Are you uing Data Validation or a Combo
Box or a List Box from theView Toolbars Forms menu? Regards, Alan. "Marilyn" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula does not work with drop down box
Thanks Alan I'm using data validation
"Alan" wrote: How are you adding a dropdown list? Are you uing Data Validation or a Combo Box or a List Box from theView Toolbars Forms menu? Regards, Alan. "Marilyn" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula does not work with drop down box
I tested it and it works. I validated a cell as 'List' and entered 'Full
Time,Part Time' in the dialogue box. In your formula that you posted here there's a space after Full Time, =IF(B12="Full Time ")....... Could that be it? Regards, Alan. "Marilyn" wrote in message ... Thanks Alan I'm using data validation "Alan" wrote: How are you adding a dropdown list? Are you uing Data Validation or a Combo Box or a List Box from theView Toolbars Forms menu? Regards, Alan. "Marilyn" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula does not work with drop down box
Thanks Alan Now it works I was using a named range
"Alan" wrote: I tested it and it works. I validated a cell as 'List' and entered 'Full Time,Part Time' in the dialogue box. In your formula that you posted here there's a space after Full Time, =IF(B12="Full Time ")....... Could that be it? Regards, Alan. "Marilyn" wrote in message ... Thanks Alan I'm using data validation "Alan" wrote: How are you adding a dropdown list? Are you uing Data Validation or a Combo Box or a List Box from theView Toolbars Forms menu? Regards, Alan. "Marilyn" wrote in message ... 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 |
Reply |
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) |