+ Reply to Thread
Results 1 to 2 of 2

Need Help With Text Formula

  1. 12-05-2014, 01:52 PM #1
    aross1990
    aross1990 is offline
    Registered User
    Join Date
    12-05-2014
    Location
    AZ
    MS-Off Ver
    2013
    Posts
    1

    Question Need Help With Text Formula

    I need a formula that will insert a specific text value in one cell if another cell equals another specific text value.

    For example:

    I need cell C1 to equal "Apple" if B1 equals "Orange"

    Can anyone help?
    Reply With QuoteRegister To Reply
  2. 12-05-2014, 01:59 PM #2
    mcmahobt
    mcmahobt is offline
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,907

    Re: Need Help With Text Formula

    Will this work?

    Please Login or Register  to view this content.
    Spread the love, add to the Rep

    "None of us are as smart as all of us."
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Copy Value String text of Formula become Formula but the formula not automatically active
    By Yovan Wisnu in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  2. FORMULA ISSUE: Formula to find specific text and replace with alternate text
    By rhale27 in forum Excel General
    Replies: 3
    Last Post: 03-04-2014, 01:47 PM
  3. Formula to find and return text string within a cell full of text strings
    By LightingPop in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-03-2013, 11:45 PM
  4. [SOLVED] Extract text from a string of text (amend formula to include new criteria)
    By robertguy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-10-2013, 04:53 PM
  5. How to do a text formula in order to when typing a text it cause another text to pop
    By hayley_1485 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-03-2010, 01:11 PM

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1