+ Reply to Thread
Results 1 to 3 of 3

If cell has a numeric value then text

  1. #1
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Post If cell has a numeric value then text

    hello

    If cell d1 =>0(zero) then
    k1 = "blue"

    if cell d1 = "any word" then
    k1 = ""

    i mean if d1 have numeric value then result should be "blue" in k1

    if

    d1 have a words then result should be ""

    thanx

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: If cell has a numeric value then text

    Here!

    =IF(ISNUMBER(D1),"Blue","")

    Deep
    Cheers!
    Deep Dave

  3. #3
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,095

    Re: If cell has a numeric value then text

    thanx msexcelathome

    works perfect

    +1 repu added to u

+ 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] Compare a text cell with a numeric cell and output a text string
    By ids in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-25-2014, 07:39 AM
  2. Replies: 7
    Last Post: 02-25-2014, 02:00 AM
  3. reading non numeric text in a cell
    By redneck joe in forum Excel General
    Replies: 2
    Last Post: 04-01-2009, 11:31 AM
  4. Numeric Cell Value with text description
    By Paco86 in forum Excel General
    Replies: 2
    Last Post: 06-21-2006, 07:10 AM
  5. Replies: 4
    Last Post: 02-06-2006, 03:05 AM

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