+ Reply to Thread
Results 1 to 10 of 10

Multiply Text Answer = Certain Cell Reponse

  1. #1
    Registered User
    Join Date
    01-12-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    7

    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

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2010
    Posts
    4,909

    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. #3
    Valued Forum Contributor
    Join Date
    05-13-2010
    Location
    Belo Horizonte, Brazil
    MS-Off Ver
    Excel 2003; 2007
    Posts
    441

    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.
    ...If my answer helped you, Please, click on. * Add Reputation (at left)

    Best regards.
    Marcílio Lobão

  4. #4
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Multiply Text Answer = Certain Cell Reponse

    Formula: copy to clipboard
    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. #5
    Registered User
    Join Date
    01-12-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    7

    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
    Last edited by Ravensp; 03-22-2018 at 12:23 AM.

  6. #6
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Multiply Text Answer = Certain Cell Reponse

    That's not what your original question asked for.

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


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

  7. #7
    Registered User
    Join Date
    01-12-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    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. #8
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Multiply Text Answer = Certain Cell Reponse

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

  9. #9
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    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. #10
    Registered User
    Join Date
    01-12-2017
    Location
    Australia
    MS-Off Ver
    2016
    Posts
    7

    Re: Multiply Text Answer = Certain Cell Reponse

    Works thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. multiply on a text answer
    By pogo827 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-13-2016, 06:19 AM
  2. Replies: 7
    Last Post: 08-25-2014, 12:08 PM
  3. Multiply values make up a cell answer
    By riyo91 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-05-2010, 05:56 AM
  4. Multiply Text Cell to Multiple Outputs
    By NewMediAroused in forum Excel General
    Replies: 5
    Last Post: 04-07-2009, 12:08 AM
  5. [SOLVED] multiply 2 listboxes and put the answer in a textbox
    By gem in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2006, 08:45 AM
  6. [SOLVED] multiply two numbers and show the answer in a textbox
    By gem in forum Excel General
    Replies: 5
    Last Post: 06-13-2006, 07:10 PM
  7. How do I multiply 1 cell x 1 cell and answer in 3rd cell?
    By Melody in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-29-2006, 09:55 PM

Bookmarks

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