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