Simple IF/AND Formula

[Dazzawm]

My mind has gone blank! I need a formula to do the following please.

If AD2 equals P380 and AE2 equals Indicator then yes, if not no.

Thanks

 

[Special-K99]

You havent said whether P380 is a value or a cell reference, Im assuming cell reference, there's an example of a value in the formula

IF(AND(AD2=P380,AE2="indicator"),"Yes","No")

 

[Dazzawm]

P380 is a value. But when I use the fill handle to go down it increases to P381, P382....?

 

[Special-K99]

It sounds like it's a cell

This is a value, it will not change when dragging.
IF(AND(AD2="P380",AE2="indicator"),"Yes","No")

This is a cell, it will change when dragging.
IF(AND(AD2=P380,AE2="indicator"),"Yes","No")

 

[Declamatory]

I think Excel thinks it's a cell reference rather than a value.

Try:

IF(AND(AD2="P380",AE2="indicator"),"Yes","No")

 

[Dazzawm]

Thank you both