Results 1 to 10 of 10

Formula returns #Value! when + empty cell with formula with cell with value and formula

Threaded View

  1. 04-11-2024, 03:55 AM #1
    varbergt
    varbergt is offline
    Registered User
    Join Date
    12-22-2023
    Location
    Denmark
    MS-Off Ver
    365
    Posts
    59

    Formula returns #Value! when + empty cell with formula with cell with value and formula

    Hello,

    In Column G I am adding column D + Column F.
    Row 2 and 3 are fine.
    Problem is row 4 and 5. This is because D4 and F5 are blank with formula. Hence, the #value!.
    Is there a way to overcome this?

    Thanks!


    10.png
    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] How to input formula in a cell with VBA if the formula returns string?
    By LIL2606 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-25-2019, 12:10 PM
  2. [SOLVED] Difficulty adding value to exclude criteria in formula. Cell with formula returns blank.
    By ZMAFC94 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-06-2018, 07:54 AM
  3. Pivot table picks up empty cell from formula which returns BLANK
    By donyc in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-11-2013, 08:37 PM
  4. [SOLVED] formula =Cell returns 0 if cell is empty - can it be blank?
    By jowes in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-05-2013, 08:36 AM
  5. [SOLVED] need formula that finds phone #, if true, returns empty cell
    By jessexcel in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 05-23-2013, 11:44 PM
  6. Formula for doing something when a cell has a formula but returns a blank.
    By rmb623 in forum Excel General
    Replies: 10
    Last Post: 01-06-2011, 01:02 PM
  7. Formula returns #Value! empty cell value
    By ingineu in forum Excel General
    Replies: 4
    Last Post: 10-02-2006, 05:49 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1