Results 1 to 5 of 5

How can I return a blank cell as blank using the IF function?

Threaded View

  1. 08-31-2024, 03:13 AM #1
    yui_2000
    yui_2000 is offline
    Registered User
    Join Date
    08-31-2024
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    12

    How can I return a blank cell as blank using the IF function?

    How can I return a blank cell as blank using the IF function?

    Screenshot 2024-08-31 114104.png
    For example, I want the E3 cell blank to be represented as B3 (not "0") due to the calculation result of the IF function.

    Anyone help?
    Last edited by yui_2000; 08-31-2024 at 12:17 PM. Reason: Solved
    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. Return blank cell for IFS formula for Vlookup data with blank cells.
    By kmac1903 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2023, 10:04 AM
  2. Return value for first consective blank cell, ignore proceeding blank cells
    By hollywoodj20 in forum Excel General
    Replies: 2
    Last Post: 08-13-2018, 02:30 AM
  3. [SOLVED] If two cells are blank then return blank, else vlookup cell with populated data
    By Jason G in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-06-2017, 10:20 AM
  4. How to Make Cells with Data Validation Lists Return Blank if a previous cell is Blank
    By MayBTheresHope in forum Excel General
    Replies: 1
    Last Post: 07-22-2016, 04:03 PM
  5. Return first non blank cell (cells have formulas that return blank)
    By BG1983 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-05-2016, 04:06 PM
  6. [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
  7. [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

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