Multiply Text Answer = Certain Cell Reponse

Hi

=IF(U1273="TKBV","Yes",IF(U1273="TKBV","Yes","No"))

I want to make it that if it sees either


TKBV
or
TKWV

it will put in cell U1273

"Yes"

If it has any other text it will put
"No"

So far i can get it to work with only one value entered but i need it to see multiply values
and for the life of me cant work it out.

Thank you for your help

Try :

=IF(OR(U1273="TKBV",U1273="TKWV"),"Yes","No")

Or:

=IF(OR(U1273={"TKBV","TKWV"}),"Yes","No")

Formula:

Please Login or Register  to view this content.

But that won't put the result in U1273 as this is what you are testing.

That's not what your original question asked for.

In W1273 put;

Formula:

Please Login or Register  to view this content.

in Q1273 put;

Formula:

Please Login or Register  to view this content.

Sorry was meant to be all for W1273

not sure why i put Q1273
must have been a typo... i am old forgive me

So in W1273 put;

Formula:

Please Login or Register  to view this content.

If it's not working attach your sample workbook showing where you have entered the formula and what is showing.

Works thank you so much