+ Reply to Thread
Results 1 to 3 of 3

Return cell, if cell is blank (ignorer formula in blank cell) return cell X

  1. #1
    Registered User
    Join Date
    07-20-2012
    Location
    utah
    MS-Off Ver
    Excel 2010
    Posts
    13

    Return cell, if cell is blank (ignorer formula in blank cell) return cell X

    I want cell X to return cell Y but if cell Y is blank, I want cell X to return cell Z. Cell Y haves a formula in it so it isn't registering a blank cell to cell X. How do I get cell X to read the cell as blank when the formula in cell Y is returning a blank cell?
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,406

    Re: Return cell, if cell is blank (ignorer formula in blank cell) return cell X

    Hi,

    Maybe in G5

    =IF(F5=0,F6,F5)

    and G6

    =IF(F6=0,0,F6)
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    07-20-2012
    Location
    utah
    MS-Off Ver
    Excel 2010
    Posts
    13

    Re: Return cell, if cell is blank (ignorer formula in blank cell) return cell X

    There is no G6 I want either/or f cells to return into G5 but this gave me an idea and seems to be working. I have the f cells formulas return 0 instead of blank. Now I can use =IF(F5="0",F6,F5)
    Last edited by twrtleduck; 11-16-2021 at 06:04 PM.

+ 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: 4
    Last Post: 02-26-2020, 04:06 AM
  2. [SOLVED] Formula to Return cell adress for next non-blank cell in a range
    By jmca2000 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-03-2016, 03:15 PM
  3. [SOLVED] When my formula encounters a blank cell it returns a 0, I need it to return a blank
    By stretch99 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-27-2014, 07:52 PM
  4. [SOLVED] Cell referenced in formula has no information displayed (shows blank), return blank cell
    By nunayobinezz in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-07-2013, 04:51 PM
  5. Replies: 2
    Last Post: 02-09-2013, 12:54 PM
  6. [SOLVED] Need formula to return blank instead of #N/A when source cell is blank, using VLOOKUP
    By TMB1234 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-03-2013, 07:16 PM
  7. Replies: 5
    Last Post: 03-23-2011, 07:09 PM

Tags for this Thread

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