How do I make a cell contain a particular word, when two separate cells contain two separate words?

[eleanorhayes86]

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

 

[jeffreybrown]

Try like this instead...

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

 

[DeusXv]

Delete

 

[jeffreybrown]

Hi DeusXv,

Not sure why you flipped the "PM" and "Yes" on the OP?

 

[DeusXv]

Hi DeusXv,

Not sure why you flipped the "PM" and "Yes" on the OP?

I had the reply button clicked while I was messing around with it so I couldn't see other posts and I ended mine with NA() cos that's the only way I know how did know you could use "" to end an if.

But to avoid any hassle I will report mine and get it removed, I should just refresh next time before I post.

 

[jeffreybrown]

No, no need to report it, just pointing out you switched the OPs variables...

 

[eleanorhayes86]

Hi DeusXv,

That's worked exactly how I wanted it to. Thanks