+ Reply to Thread
Results 1 to 4 of 4

Help with replacing #VALUE! With blank cell

  1. 08-23-2013, 03:23 AM #1
    Khaldon
    Khaldon is offline
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Question Help with replacing #VALUE! With blank cell

    The formulas in cells T3 and T6 from the attached sample sheet calculates appropriately,

    However, if cell B3 is blank, it returns a #VALUE! error on my original excel sheet with all the reference cells exist.

    I would like please the cells T3 and T6 to be blank when cell B3 is blank.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 08-23-2013, 03:32 AM #2
    ramananhrm
    ramananhrm is offline
    Valued Forum Contributor
    Join Date
    09-15-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2010
    Posts
    436

    Re: Help with replacing #VALUE! With blank cell

    You can use this function

    =IF($B$3="","",P1-F1)

    Or

    If you want to hide the error, then you can go for 'IFERROR' Syntax
    =IFERROR(P1-F1,"")

    Or

    Use Conditional formatting
    =ISERROR(T1)

    Or

    Im wrong in understanding your query
    Please click 'Add reputation', if my answer helped you.
    Reply With QuoteRegister To Reply
  3. 08-23-2013, 03:37 AM #3
    amy_d2
    amy_d2 is offline
    Forum Contributor
    Join Date
    05-24-2013
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    291

    Re: Help with replacing #VALUE! With blank cell

    hi

    This in T3 =IF(B3="","",P3-F3)
    & this in =IF(B3="","",IF(MIN(R3,T3)-C3<G3,FALSE,MIN(R3,T3)-C3))


    check if you really want this
    Click on * below if you find this helpful

    Thanks,
    A
    Reply With QuoteRegister To Reply
  4. 08-23-2013, 03:53 AM #4
    Khaldon
    Khaldon is offline
    Forum Contributor
    Join Date
    04-18-2011
    Location
    Jeddah
    MS-Off Ver
    Excel 2007
    Posts
    362

    Re: Help with replacing #VALUE! With blank cell

    You got it, and the first formula did the job.

    Thank you,
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Replacing a blank with info from cell above
    By Accountnt in forum Excel General
    Replies: 9
    Last Post: 08-06-2013, 06:01 AM
  2. [SOLVED] not showing 0 in a cell or replacing it with a blank cell
    By Zealotwraith in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 07-26-2013, 03:40 PM
  3. Replacing a blank with a value
    By bmccarthy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-29-2010, 09:12 AM
  4. replacing '0' with a blank cell; working out %'s as and when figures are entered.
    By pippam in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-25-2008, 07:28 AM
  5. Replacing #N/A with a blank cell
    By sandrav in forum Excel General
    Replies: 2
    Last Post: 06-24-2008, 11:30 AM

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