Results 1 to 5 of 5

Return the value of a cell if blank otherwise return empty cell

Threaded View

  1. 07-29-2021, 06:59 AM #1
    Oghenovo
    Oghenovo is offline
    Registered User
    Join Date
    07-27-2021
    Location
    UK
    MS-Off Ver
    365
    Posts
    8

    Return the value of a cell if blank otherwise return empty cell

    Hello everyone, Please I would like assistance regarding the attached excel sheet on the formula. Given the column A and column B in the spreadsheet, I need to find D. Such that D2 is equal to A2 only when the cell B2 is empty, otherwise cell D2 will display an empty cell (nothing), this applies consecutively to other cells. Thank you.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. [SOLVED] Need to return a blank when source cell is empty
    By Mendonk in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-10-2021, 05:03 AM
  2. IFERROR with Index Match need to return numeric empty cell not text empty cell
    By olga6542 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-30-2020, 02:07 AM
  3. [SOLVED] If a cell is blank/empty return a value or perform a calculation
    By mel_lopez in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 04-28-2016, 05:27 AM
  4. [SOLVED] help! Date formula to Return blank if cell is empty
    By marquint in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-08-2014, 01:32 AM
  5. Date formula to Return blank if cell is empty
    By Ctaxes in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-07-2014, 11:28 PM
  6. If statement to return blank if cell D1 is empty...
    By bendixboogie in forum Excel General
    Replies: 8
    Last Post: 11-11-2008, 05:00 PM
  7. Return an empty or blank cell value?
    By Troymello in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-03-2006, 01:45 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