+ Reply to Thread
Results 1 to 5 of 5

Looking for a formula- if a cell is blank, it is equal to the cell next to it

  1. #1
    Registered User
    Join Date
    04-29-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Looking for a formula- if a cell is blank, it is equal to the cell next to it

    Hi everyone, I'm doing a data entry task for packaged food products.

    Lets say we have a cell D1. I don't know if D1 is blank or not. If D1 is blank, I want its value to be equal to the value of cell E1. Is there a formula for this?

  2. #2
    Valued Forum Contributor
    Join Date
    04-22-2014
    Location
    Auckland, New Zealand
    MS-Off Ver
    Office 365 (work) and Excel 2013 (home)
    Posts
    1,167

    Re: Looking for a formula- if a cell is blank, it is equal to the cell next to it

    Not in D1, but in F1 you could add =if(D1="",E1,D1).

  3. #3
    Registered User
    Join Date
    05-04-2014
    Location
    Milwaukee, WI
    MS-Off Ver
    Excel 2007, 2010, 2013
    Posts
    4

    Re: Looking for a formula- if a cell is blank, it is equal to the cell next to it

    If, as in your example, you are always looking at column D and if column D is blank you are always looking at column E then I would use the following:

    =IF(ISBLANK(D1)=true, E1, D1)

    Now if you are looking for if column D is blank then check for the next in the row that isn't blank, then you've gotten too complicated for me as I would just start stringing together embedded IF statements, which really slows down the sheet. Try the formula above and see if it helps.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Looking for a formula- if a cell is blank, it is equal to the cell next to it

    From the sounds of it, D1 is supposed to contain data, but you are unsure if it does or not?

    A cell can contain either data OR a formula, not both. So if you have a formula in D1 that references E1, as soon as you enter something in D1, that formula gets over-written

    I think you are going to need to explain a bit more - and maybe provide a sample workbook - so we understand better?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Registered User
    Join Date
    04-29-2014
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2013
    Posts
    6

    Re: Looking for a formula- if a cell is blank, it is equal to the cell next to it

    Hmm, ok.

    So to give a bit of background: I have a 2000 odd list of data on packaged drink products that I have to decompose into flavor, natural/organic, product name, etc.

    What I've done so far is use the formula =IF(ISNUMBER(FIND("FLAVOR",cell)),"Flavor","") in the each column next to the original data. Each column has a different flavor in place of FLAVOR.

    So now I have a bunch of columns next to the original data, one for Strawberry, one for Grape, one for Orange, etc. I've alsoedited the columns so that the original formulas are gone, and only the values are left over.

    Want I want to do is put all those columns together into one 'Flavor' column. Is there any quick and simple way to do this?

+ 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. Replies: 1
    Last Post: 11-28-2013, 02:16 AM
  2. Replies: 2
    Last Post: 10-08-2013, 11:19 PM
  3. Formula to equal next cell below with value if cell below is blank
    By EoghanMBH in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-14-2012, 12:57 AM
  4. when is equal not equal - cell reference results to blank cell
    By riwiseuse in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-10-2009, 09:44 AM
  5. Blank (empty) cell always equal to 0??
    By ulfah in forum Excel General
    Replies: 3
    Last Post: 02-01-2006, 01:00 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