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