eleanorhayes86
New Member
- Joined
- Sep 3, 2013
- Messages
- 2
I am creating a database in Excel 2010, where we have many job positions that need to be filled.
I would like to have a column that lists the positions that are required and a column beside it that will have a formula, which will say the word "Filled" in it if one cell contains the word "PM" as well as another cell having the word " Yes".
The A column has the list of Positions including PM, and B column has whether we the candidate is employed, Yes or No.
I think that the formula should look as written below, but it does not work. Is there any way of doing this?
=IF(AND(A1="PM")*(B1="Yes"),"Filled","")
Thanks
I would like to have a column that lists the positions that are required and a column beside it that will have a formula, which will say the word "Filled" in it if one cell contains the word "PM" as well as another cell having the word " Yes".
The A column has the list of Positions including PM, and B column has whether we the candidate is employed, Yes or No.
I think that the formula should look as written below, but it does not work. Is there any way of doing this?

=IF(AND(A1="PM")*(B1="Yes"),"Filled","")
Thanks
