+ Reply to Thread
Results 1 to 4 of 4

Populate from a specific cell if it is a number?

  1. #1
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Populate from a specific cell if it is a number?

    In cell A1, I want it to preferably populate with the contents of B2. However if B2 contains 0 or says #N/A N/A then I'd like it to populate with C2. If C2 ALSO contains 0 or says #N/A N/A then just populate with the 0.

    At the moment, I can only get this to work if the cell says 0 or #VALUE!, but I need it to work for generally anything other than a number. This is my current formula:

    =IF(ISERROR(B2),IF(ISERROR(C2),0,C2),IF(B2=0,IF(ISERROR(C2),0,C2),B2))

    Does anyone have any suggestions? :/ Thanks!

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Populate from a specific cell if it is a number?

    This sort of contradicts your title
    Quote Originally Posted by kellyfirth View Post
    but I need it to work for generally anything other than a number
    So B2 and/or C2 will normally contain a TEXT string, not a number?
    And you want the text string, preferably from B2
    If neither has a text string, then return 0 ?

    Try
    =IF(ISTEXT(B2),B2,IF(ISTEXT(C2),C2,0))


    If what you really meant is for any number...
    Just change the ISTEXT functions to ISNUMBER
    Last edited by Jonmo1; 02-13-2015 at 09:37 AM.

  3. #3
    Registered User
    Join Date
    11-25-2014
    Location
    Isle of Man
    MS-Off Ver
    Microsoft Excel 2010
    Posts
    82

    Re: Populate from a specific cell if it is a number?

    Apologies for my lack of clarity! You understood what I meant, it was the ISNUMBER I needed, this worked great! Thank you!! :D

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Populate from a specific cell if it is a number?

    OK

    Acutally that doesn't quite resolve the other requirement..
    If B2 = 0 then look at C2..

    Try
    =IF(ISNUMBER(B2),IF(B2<>0,B2,IF(ISNUMBER(C2),C2,0)))

+ 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. I need to populate a given number of rows starting at a specific location
    By nmetayer in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-03-2014, 01:06 PM
  2. Replies: 1
    Last Post: 11-21-2013, 06:07 AM
  3. Having issue trying to get a specific value to populate in another cell
    By defilted in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-01-2013, 01:29 PM
  4. [SOLVED] Populate dates for specific number of times
    By krash297 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-11-2013, 12:40 AM
  5. Replies: 1
    Last Post: 02-20-2013, 05:14 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