+ Reply to Thread
Results 1 to 4 of 4

IF formula to return value in one cell based on any text in another?

  1. #1
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    IF formula to return value in one cell based on any text in another?

    Basically need to know what to put in formula to enter a value based on any text being entered into another.


    B1 = formula goes here - will return a value of ".50" if any text is entered into A1
    A1 = cell to check for any text
    If no text is entered into A1, then B1 will remain blank.

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,202

    Re: IF formula to return value in one cell based on any text in another?

    =if(a1="","",0.5)

  3. #3
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: IF formula to return value in one cell based on any text in another?

    or
    =IF(ISTEXT(A1),0.5,"")

  4. #4
    Forum Contributor
    Join Date
    07-06-2013
    Location
    USA
    MS-Off Ver
    MS Office 2019 Pro Plus
    Posts
    182

    Re: IF formula to return value in one cell based on any text in another?

    thanks 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. [SOLVED] Formula to Return Text Result Based On Text Contained in Cell
    By ShawnaLynn in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-10-2021, 12:40 PM
  2. Replies: 3
    Last Post: 11-05-2020, 11:16 PM
  3. Replies: 1
    Last Post: 04-04-2019, 11:35 PM
  4. [SOLVED] Formula to return text based on two criteria
    By KClem in forum Excel General
    Replies: 6
    Last Post: 10-16-2017, 02:16 PM
  5. Replies: 3
    Last Post: 12-03-2014, 05:43 PM
  6. Trying to Return a Number in a Cell based on Text
    By jslavinsky in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-01-2014, 03:17 PM
  7. VLOOKUP return value based on text in cell
    By Detrie in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-04-2014, 07:17 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