+ Reply to Thread
Results 1 to 2 of 2

If cell is not a number, then return a value

  1. 08-06-2013, 05:05 PM #1
    Ocean Zhang
    Ocean Zhang is offline
    Forum Contributor
    Join Date
    05-29-2009
    Location
    Chattanooga, TN
    MS-Off Ver
    2021
    Posts
    205

    If cell is not a number, then return a value

    what formula would I use to get a value whenever a cell is not a number?

    A1: 34 => leave blank ""
    A1: monday => return a value of "value"

    Thanks!
    Last edited by Ocean Zhang; 08-06-2013 at 05:26 PM.
    Reply With QuoteRegister To Reply
  2. 08-06-2013, 05:12 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: If cell is not a number, then return a value

    =if(isnumber(a1), "", "value")
    Entia non sunt multiplicanda sine necessitate
    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. Find a string withing cell range and return cell number
    By visak in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-16-2015, 09:19 PM
  2. if statement to find a number and return that number in a cell
    By Neelam82 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-08-2013, 10:22 PM
  3. [SOLVED] Find cell value and return even number on adjacent cell
    By Surya51 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-29-2012, 01:03 PM
  4. [SOLVED] Return the value of the first cell in a row that contains a number
    By marcdg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-03-2012, 09:30 PM
  5. If a cell is blank(not zero) return 0 if it is a number or 0 return 10?
    By jaganath in forum Excel General
    Replies: 5
    Last Post: 03-12-2010, 07:33 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1