# Multiply Text Answer = Certain Cell Reponse

1. ## 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.

2. ## Re: Multiply Text Answer = Certain Cell Reponse

Try :

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

Or:

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

3. ## Re: Multiply Text Answer = Certain Cell Reponse

Ravensp, Good evening.

Try to use:
``Please Login or Register  to view this content.``
Is that what you want?

I hope it helps.

4. ## Re: Multiply Text Answer = Certain Cell Reponse

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.

5. ## Re: Multiply Text Answer = Certain Cell Reponse

Hi

So that did not work

Basically trying to get data to enter if

U1273 if i put in either TKBV or TKWV it would put in cell W1273 "Yes"
but if i enter any other data in U1273 it would put in cell W1273 "No"

Thank you

6. ## Re: Multiply Text Answer = Certain Cell Reponse

In W1273 put;
Formula:
`Please Login or Register  to view this content.`

in Q1273 put;
Formula:
`Please Login or Register  to view this content.`

7. ## Re: Multiply Text Answer = Certain Cell Reponse

Sorry was meant to be all for W1273

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

8. ## Re: Multiply Text Answer = Certain Cell Reponse

So in W1273 put;
Formula:
`Please Login or Register  to view this content.`

9. ## Re: Multiply Text Answer = Certain Cell Reponse

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

10. ## Re: Multiply Text Answer = Certain Cell Reponse

Works thank you so much

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1