Results 1 to 4 of 4

Thread: Calculation after using IFERROR
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Nov 2018
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Calculation after using IFERROR

    Hi,
    I have used IFERROR function which returns cell (B5) to blank cell e.g. Cell B5 shows blank cell. I want to display cell B5 as numeric (which comes from VLOOKUP) or blank cell (if value is not available in table). But I also want add cell B5 and cell B6 and display addition in cell B7. Cell B6 is having some numeric e.g. 5.
    In above case, Cell B7 should show addition as 5 (0+5) but it shows #value!.

    Please suggest solution for above query.

    Thanks in advance.

    Regards,
    Pradeep

  2. #2
    MrExcel MVP
    Junior Admin
    Joe4's Avatar
    Join Date
    Aug 2002
    Posts
    50,715
    Post Thanks / Like
    Mentioned
    57 Post(s)
    Tagged
    11 Thread(s)

    Default Re: Calculation after using IFERROR

    It doesn't link to add 5 to blank.
    I think it would be better to have your IFERROR return 0, instead of blank, and simply use Custom Formatting or Conditional Formatting to hide the 0.
    TIPS FOR FINDING EXCEL SOLUTIONS
    1. Use the built-in Help that comes with Excel/Access
    2. Use the Search functionality on this board
    3. A lot of VBA code can be acquired by using the Macro Recorder.

    "Give a man a fish, feed him for a day. Teach a man to fish, feed him for life!"

  3. #3
    Board Regular
    Join Date
    Mar 2014
    Posts
    2,427
    Post Thanks / Like
    Mentioned
    11 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Calculation after using IFERROR

    Enter =SUM(B5:B6) into B7.

  4. #4
    New Member
    Join Date
    Nov 2018
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Calculation after using IFERROR

    Hi,

    Thanks for the reply.
    It is working fine at my end.....

    Thanks for the solution.

    Regards,
    Pradeep

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •